While during the
Restore Process , always try to set the database is in Single user Mode
During the restore process if the alert shows Exclusive access could not be obtained because the database is in use as follows
To resolve , Exec SP_who , identify if any user is still accessing the restore database and status will be in sleeping mode as follows.
kill 53
kill 54
No comments:
Post a Comment