Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restoring backup requires Single User
Message
From
22/11/2021 13:25:28
 
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
01682769
Message ID:
01682775
Views:
27
>
>ALTER DATABASE DatabaseName
>SET MULTI_USER;
>
>?

All the databases are set to multi user. This has always been the setting everywhere. Since recently, the only way I can do a restore is to switch to single user. The location of the restore is from my local PC. I even restarted SQL Server service and nothing else is querying the server. Then, I execute the restore and it always cannot get access to the database in exclusive mode. This has worked for years.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform