Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restoring backup requires Single User
Message
 
 
À
22/11/2021 13:25:28
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
01682769
Message ID:
01682787
Vues:
35
>>
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform