I'm an accidental DBA. My production environment is on a standard verison of Sql Server 2008. I ran the following query:
SELECT name, log_reuse_wait_desc FROM sys.databases
All my databases are ok and go between Log Backup and Nothing, except for the master database. I have check several times and it seems to be stuck in the Database Snapshot Creation. If I do a backup of the master database it goes back into the nothing mode and stays that way for the remainder of the day. However, every morning it is stuck back in the Database Snapshot creation. I am not certain what is causing this since it is not Enterprise edition so snapshots can not be created. Any hints or ideas would be appreciated.
SELECT name, log_reuse_wait_desc FROM sys.databases
All my databases are ok and go between Log Backup and Nothing, except for the master database. I have check several times and it seems to be stuck in the Database Snapshot Creation. If I do a backup of the master database it goes back into the nothing mode and stays that way for the remainder of the day. However, every morning it is stuck back in the Database Snapshot creation. I am not certain what is causing this since it is not Enterprise edition so snapshots can not be created. Any hints or ideas would be appreciated.
