-- Returns a result set consisting of a list of databases and log files contained in the backup set.
-- main get logical file name
Span style= "color: #0000ff;" >use master
restore filelistonly
from disk =< Span style= "color: #000000;" > ' g:\back. Bak ' &NBSP;
go< Span style= "color: #000000;" >
************************************************
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
*/
UseMaster
RESTOREDATABASEDb
FromDISK=‘G:\back. Bak‘
WithMOVE‘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=10,REPLACE
GO
++++++++++++++++++++++++++++++++
Back up the data db to the. bak file. This bak file is then used to recover a new database dbtest.
*/
UseMaster
BACKUPDATABASEDb
ToDISK=‘G:\DBBack0930.bak‘
RESTOREFilelistonly
FromDISK=‘G:\DBBack0930.bak‘
RESTOREDATABASEDBTest
FromDISK=‘G:\DBBack0930.bak‘
WithMOVE‘DBTest‘To e:\program files\microsoft sql server2005\data\dbtest.mdf ' ,
move dbtest_log '
Source: http://www.cnblogs.com/adandelion/archive/2006/09/30/519534.html
/**//*
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
*/
UseMaster
RESTOREDATABASEDb
FromDISK=‘G:\back. Bak‘
WithMOVE‘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=10,REPLACE
GO
++++++++++++++++++++++++++++++++
/**//*
Back up the data db to the. bak file. This bak file is then used to recover a new database dbtest.
*/
UseMaster
BACKUPDATABASEDb
ToDISK=‘G:\DBBack0930.bak‘
RESTOREFilelistonly
FromDISK=‘G:\DBBack0930.bak‘
RESTOREDATABASEDBTest
FromDISK=‘G:\DBBack0930.bak‘
WithMOVE‘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
---******************************
Database backup and restore