Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sourav Mukherjee Kill all USer Sessions before starting to restore a Database RE: Kill all USer Sessions before starting to restore a Database
Oliver Wootton
SSC Veteran
Points: 291
More actions
August 27, 2015 at 6:51 am
#1822736
Why not ?
USE master
go
ALTER DATABASE <your database name> SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE <your database name> SET ONLINE