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

  • August 5, 2015 at 2:24 am

    #1817399

    USE [master]

    GO

    ALTER DATABASE [MyDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    RESTORE DATABASE MyDatabase FROM ...