Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2014-03-26 : 19:00:58
|
| we have witnessed on SQL 2008 R 2 Server's instance a database have just became invisible during the time of its Full backup Schedule time and it has re-appeared back once.The Database has turned into SINGLE-USER MODE.if database is in SINGLE-USER Mode then will it not picked up for backup?When Checked from Errorlogs:Setting database option READ_COMMITTED_SNAPSHOT to ON for database Trial1.is above statement from ErrorLogs have any Manual intervention is possible or is it automatic setup for the database Trial1 to be SINGLE-USER Mode?Could anyone explain this scenario. |
|
|
|
|
|
Instance Databases visibility