Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Log_reuse_wait_desc stuck in Database Snapshot Creation

Status
Not open for further replies.

metevil80

Programmer
Feb 9, 2011
19
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top