Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restoring backup requires Single User
Message
 
 
To
22/11/2021 13:25:28
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
01682769
Message ID:
01682787
Views:
34
>>
>>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.

Are you running SSMS as Admin? Also, what is your default DB when you start SSMS? You need to make sure you're connecting to master before restoring.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform