Exclusive access could not be obtained because the database is in use. RESTORE DATABASE terminated running Automated restored (4250435)

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Exclusive access could not be obtained because the database is in use. RESTORE DATABASE terminated running Automated restored
Description

Automated restore fail during execution due DB is in exclusive Access
Cause

Automated restore is a subset of Steps. based in

Scanning: Step to identify the Candidate files for Restore

Restoring: Once the files have been identified the restore process starts applying the files Candidates

If any application reconnect to the Database during the Scanning Step the Exclusived mode is lost and the Restore Files (Exclusive mode is a must for SQL Server Restore)
Résolution

WORAKOUND

Add 2 scripts to your Automated restore Job

1. Kill all Session to the DB

2. Lock access to the DB via an Alter to set the DB Offline or Single User

STATUS

Issue fixed in version 8.9.7. The latest version of LiteSpeed for SQL Server t can be downloaded here
Identifiant du défaut

LS-2338

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 2/26/2021
Dernière mise à jour le : 7/4/2024

Titre