question

raadee avatar image
raadee asked

Attach database fails. Translog is full due to Checkpoint.

SQL Express 2012 A customer installed Sharepoint with SQL Express on C:\. C:\ fills up. The database that filled up the drive (transaction log grew big) is detached while log_reuse_desc is Checkpoint. Data/Log file is moved to another drive, attach fails with message: > The transaction log for database 'SharepointDB' is full due to 'checkpoint' > Could not write checkpoint record in database because the log is out of space > Error 9002 No backups exists (except for the file copy backup of mdf/ldf that I did. Any suggestions on how to attach the database without messing around with allow_data_loss and similar? /*Update This is a virtual server. Customer 'shapshots' their entire environment so there is a exact copy of this server running in an isolated environment. The status of this isolated copy if the production server is that the database is attached but it is still complaining that transaction log is full due to checkpoint. - No open transactions - Disk is not full - Data is accessible - Backup or any change to database settings gives checkpoint/translog error message. This system is not in production so a valid solution would be to move the older database from isolated environment to the production environment.
attach
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
This site runs off of votes. Please mark all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that answer.
0 Likes 0 ·
raadee avatar image raadee commented ·
Im waiting for more answers (hopefully).
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
Have you reviewed the Technet article on troubleshooting this error : http://technet.microsoft.com/en-us/library/ms175495.aspx My other thought is if this is not in production, what's the problem with data loss?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee avatar image raadee commented ·
Yes, none of the points mentioned in the article work for me. Whatever I do I get the checkpoint error. The system is under development/test and the server exists in two environments. In the production environment the database is detached and "not attachable" because of checkpoint error. In the "snapshotted" environment the database is attached but none of the points in the article work. I must be missing something trivial?!
0 Likes 0 ·
raadee avatar image raadee commented ·
Accepting this answer since it is the closest to solving (but strangely hasn't).
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
If there is a vm snapshot then why not start that up and add an extra logfile on a drive that has space? With the database running again you can then get the database in good shape - moving log and data files off the C:\ and fixing their size etc. The VM could have drives added from the host if necessary.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee avatar image raadee commented ·
Hi, Can't add an extra logfile (on the snapshot), I get the checkpoint error when trying to modify the database. And there is space on disk (deleted some files). Tried to run a manual checkpoint but that fails, any configuration to the database fails because of the checkpoint status.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.