Why would SQL Server get a database stuck in DATABASE_SNAPSHOT_CREATION?

Question

I've a database in a production server which has a log that is getting enormous, while trying to understand the reason, I've issued this query:

SELECT name, log_reuse_wait_desc FROM sys.databases

The database in question has DATABASE_SNAPSHOT_CREATION, and even tough the docs say it should be a momentary state, it's been in this state for 10 mins. I'm guessing it's what's keeping the log from becoming manageable.

How can I fix this?

PS: I'm using the SIMPLE recovery mode.

Answer 1

OK - Try running DBCC SQLPERF(LOGSPACE). That will tell you how much of that log file is actually being used.