Brandie Tarvin (5/16/2013)

---

Depending on the size of the logs to be shrunk, that might not be enough, but it's a good start. Try running another Checkpoint and checking all the...

I just increased it (tempdb) to 200MB data and 100MB log. I'll see if it grows upward from there.

f242337 (5/15/2013)

---

re: TEMPDB

My tempdb data has 19MB allocated of which 13MB is free, and its log has 5MB allocated of which 2MB is free.

DBCC LOGINFO shows it has 18 VLFs...

SQL2012SP1CU3 doesn't help. Actually it makes it much worse - now the databases fail recovery (b/c a checkpoint cannot be written, b/c the transaction logs are full) and cannot be...

Interesting.

checking mine:

select * from sys.sysprocesses where lastwaittype like '%LOG%' or lastwaittype like '%CHECKPOINT%' or...

I've considered recreating the entire database, because I can successfully pull all the data out via Import/Export Wizard's SSIS. In fact I have a couple copies of the database data...

re: TEMPDB

My tempdb data has 19MB allocated of which 13MB is free, and its log has 5MB allocated of which 2MB is free.

DBCC LOGINFO shows it has 18 VLFs of...

I suspect everything is hung up on figuring out how to accomplish a checkpoint. I don't understand, fundamentally, why I can't add a new log or grow an existing one....

re: SQL2012SP1CU2 & stuck transaction log KB: http://support.microsoft.com/kb/2509302

I considered that, but

#1) That KB says it is for databases in Full Recovery Model

#2) It says it occurs as...

Looking at

I see a CHECKPOINT command with a wait_type of LOGMGR_RESERVE_APPEND,...

I ran "DBCC OPENTRAN" and got an empty response (detailed in post above). 🙁

Is there something else possibly worth...

One more note. DBCC CHECKDB doesn't report any specific errors, but it cannot create a checkpoint record (because the log is out of space...), and it cannot create a snapshot...

Note: SQL2012SP1. I have not applied CU2. This fix in CU2 sounds similar, but it says it is only for FULL recovery model.

http://support.microsoft.com/kb/2509302

I have what at least superfically seems similar.

Summary: I have a simple model database which is stuck due to an overfull transaction log - can't add more log space or...

It sounds like your database server is not in a domain -- thus, it only offers you the one choice for login, that one choice being its local SAM. ...