USE MASTER

ALTER DATABASE [MyDB01] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

RESTORE DATABASE [MyDB01] FROM  DISK = 'C:\DatabaseBackup\MyDB01_20200101.bak' WITH REPLACE 

ALTER DATABASE [MyDB01] SET MULTI_USER 

ALTER DATABASE [MyDB01] SET RECOVERY SIMPLE WITH NO_WAIT  
Last modified: June 19, 2020

Author

Comments

Write a Reply or Comment