use master
alter database DBName
set single_user with rollback immediate
restore database DBName
from disk = 'C:\DBBackup.bak'
-- use the following to overwrite log in case the log file was not backed up
with replace
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment