Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restoring backup requires Single User
Message
De
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:
01682775
Vues:
28
>
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform