Viewing post 16 (of 17 total)
Instead of killing the processes, have you thought about doing this prior to the restore:
ALTER DATABASE dbname SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE dbname SET ONLINE
That ought to kill everything,...
September 30, 2009 at 6:22 am
#1059903