-- Apabila file data.dat merupakan back-up file, maka isi file tsb dilihat (sebelum direstore) adalah sbb:
/* The RESTORE FILELISTONLY statement is used to determine the number and names of the files in the database being restored. */ RESTORE FILELISTONLY FROM DISK = 'c:\data.dat' GO /* -- contoh tampilan hasil eksekusi pada sql analizer: LogicalName PhysicalName Type FileGroupName Size MaxSize --------------------------------------------------------------------------------- ---- ------------- ------- -------------- Northwind C:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf D PRIMARY 3080192 35184372080640 Northwind_log C:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf L NULL 1048576 35184372080640 (2 row(s) affected) */ -- kemudian untuk merestorenya sebagai database 'TestDB' adalah sbb: RESTORE DATABASE TestDB FROM DISK = 'c:\data.dat' GO /* -- contoh tampilan hasil eksekusi pada sql analizer: Processed 360 pages for database 'TestDB', file 'Northwind' on file 1. Processed 1 pages for database 'TestDB', file 'Northwind_log' on file 1. RESTORE DATABASE successfully processed 361 pages in 0.739 seconds (3.992 MB/sec). */ ----- Original Message ----- From: "jonind" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, March 28, 2006 10:50 AM Subject: Re: [indopb] Help me please ! Urgent ! > Bisa lebih spesifik nggak caranya gimana ? > > Best regards, Amin > > ----- Original Message ----- > From: "Technetindo Utama, PT." <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, March 28, 2006 10:14 AM > Subject: Re: [indopb] Help me please ! Urgent ! > > >> you can try to attach the database using sql/2000 with compatibility >> option >> 6.5 >> >> ----- Original Message ----- >> From: "jonind" <[EMAIL PROTECTED]> >> To: <[email protected]> >> Sent: Monday, March 27, 2006 1:50 PM >> Subject: [indopb] Help me please ! Urgent ! >> >> >>> Saya punya backup database sql 6.5 ( data.dat). Bagaimana caranya jika >>> data tersebut saya mau load dengan menggunakan sql 7/2000 ? Please help, >>> urgent! >>> >>> Best Regards, >>> Amin >>> >>> [Non-text portions of this message have been removed] >>> >>> >>> >>> ----------------------------------------------- >>> IndoPB - Indonesia PB User Group >>> To Post a message, send it to: [EMAIL PROTECTED] >>> To Unsubscribe,send a blank message to: [EMAIL PROTECTED] >>> Yahoo! Groups Links >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> Internal Virus Database is out-of-date. >>> Checked by AVG Free Edition. >>> Version: 7.1.371 / Virus Database: 267.14.7/214 - Release Date: >>> 12/23/2005 >>> >>> >> >> >> ----------------------------------------------- >> IndoPB - Indonesia PB User Group >> To Post a message, send it to: [EMAIL PROTECTED] >> To Unsubscribe,send a blank message to: [EMAIL PROTECTED] >> Yahoo! Groups Links >> >> >> >> >> >> > > > > > > ----------------------------------------------- > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > > > > -- > Internal Virus Database is out-of-date. > Checked by AVG Free Edition. > Version: 7.1.371 / Virus Database: 267.14.7/214 - Release Date: 12/23/2005 > > ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
