SQL Server Database Recovery backup

Usually we take the method of recovering the backup, select the target database, select the source device for recovery.

As follows:

2, but this way is sometimes inconvenient, and script way will be more convenient, using the script as follows.

/*
Back up the data db to the. bak file. This bak file is then used to recover a new database dbtest.
*/
UseMaster
BACKUP DATABASEDB
to DISK = ' e: \dbtest.bak'

RESTOREfilelistonly
from DISK = ' e: \dbtest.bak ' 

RESTORE DATABASEDBTest
from DISK = ' e: \dbtest.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',

STATS= Ten, REPLACE
GO 

STATS = 10 shows one record per completion 10%
REPLACE uses bak to recover the database, forcing the restore
Dbtest and Dbtest_log are above g:\back. The logical file in Bak

SQL Server Database Recovery backup