May 21, 2018 at 12:57 am
Hello
I've a database that is the secondary database of a log shipping (so it's readonly) that sometimes i found in singleuser mode.
I don't know if it depends by the logshipping but my question is, how can i find the proces/query that put database in single user?
Thanks in advance
Andrea
May 21, 2018 at 8:38 am
andrea.dimaio - Monday, May 21, 2018 12:57 AMHello
I've a database that is the secondary database of a log shipping (so it's readonly) that sometimes i found in singleuser mode.
I don't know if it depends by the logshipping but my question is, how can i find the proces/query that put database in single user?
Thanks in advanceAndrea
It may be the log shipping restore job. If you selected "disconnect users in the database when restoring backups" when setting up log shipping it generally will put the database in single user mode to do the restores. Check the job history and/or the SQL Server error log for any issues when putting the database back to multi-user.
There of course could be other things but you may want to check the log shipping process and job.
Sue
May 21, 2018 at 9:03 am
Is there some issue with this? I'm curious why/how you noticed this or are concerned.
If you bring the secondary online, you might appreciate single user, especially if you may need to restore one more log.
June 5, 2018 at 2:00 am
Hi
"disconnect users in the database when restoring backups" has been flagged but the strange things is that after restore (terminated with status OK), database "sometimes" it remains in single user mode.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply