You are here:Home » tsql » Restore Database query

Restore Database query

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'