Skip to content

Instantly share code, notes, and snippets.

@evgenylavelin-xx

evgenylavelin-xx/SQL.Восстановление базы с отключением пользователей

Created September 10, 2015 23:12
Show Gist options
  • Save evgenylavelin-xx/67f84c8bd117f8783357 to your computer and use it in GitHub Desktop.
Save evgenylavelin-xx/67f84c8bd117f8783357 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL.Восстановление базы с отключением пользователей
----Make Database to single user Mode
ALTER DATABASE YourDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
----Restore Database
RESTORE DATABASE YourDB
FROM DISK = 'D:\BackUpYourBaackUpFile.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:\DataYourMDFFile.mdf',
MOVE 'YourLDFLogicalName' TO 'D:\DataYourLDFFile.ldf'
/*If there is no error in statement before database will be in multiuser
mode.
If error occurs please execute following command it will convert
database in multi user.*/
ALTER DATABASE YourDB SET MULTI_USER
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment