Home Forums SQL Server 2008 SQL Server 2008 - General Killing all sessions and restoring the database RE: Killing all sessions and restoring the database
barsuk
SSChampion
Points: 12280
More actions
December 24, 2014 at 6:30 pm
#1766384
I usually use the below code before restore:
alter database Test
set offline with rollback immediate