restore headeronly from disk = 'C:\database\DBBackup.bak'
restore verifyonly from disk = 'C:\database\DBBackup.bak'
restore filelistonly from disk = 'C:\database\DBBackup.bak'
Restore database BackupTest
from disk = 'C:\database\DBBackup.bak'
with replace,
move 'BackupTest_Data' to 'c:\BackupTest_Data.mdf',
move 'BackupTest_Log' to 'c:\BackupTest_Log.ldf'
restore verifyonly from disk = 'C:\database\DBBackup.bak'
restore filelistonly from disk = 'C:\database\DBBackup.bak'
Restore database BackupTest
from disk = 'C:\database\DBBackup.bak'
with replace,
move 'BackupTest_Data' to 'c:\BackupTest_Data.mdf',
move 'BackupTest_Log' to 'c:\BackupTest_Log.ldf'
Comments
Post a Comment