--Returns a result set consisting of a list of databases and log files contained in the backup set.
--Main access to logical file names
Use master
RESTORE filelistonly
From DISK = ' g:\back. Bak '
Go
************************************************
/**//*
Recover database with Bak, Force restore (REPLACE)
STATS = 10 shows one record per completion 10%
Dbtest and Dbtest_log are above g:\back. The logical file in Bak
*/
Use master
RESTORE DATABASE DB
From DISK = ' g:\back. Bak '
With MOVE ' DBTest ' to ' E:\Program Files\Microsoft SQL Server2005\data\db.mdf ',
MOVE ' Dbtest_log ' to ' E:\Program Files\Microsoft SQL Server2005\data\db_log.ldf ',
STATS = ten, REPLACE
GO
++++++++++++++++++++++++++++++++
/**//*
Back up the data db to the. bak file. This bak file is then used to recover a new database dbtest.
*/
Use master
BACKUP DATABASE DB
to DISK = ' G:\DBBack0930.bak '
RESTORE filelistonly
From DISK = ' G:\DBBack0930.bak '
RESTORE DATABASE DBTest
From DISK = ' G:\DBBack0930.bak '
With MOVE ' DBTest ' to ' E:\Program Files\Microsoft SQL Server2005\data\dbtest.mdf ',
MOVE ' Dbtest_log ' to ' E:\Program Files\Microsoft SQL Server2005\data\dbtest_log.ldf '
GO
---******************************
SQL Server Restore Script-1