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.
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.