GilaMonster (10/7/2011)
Please run the following and post the full and complete results
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Hi Gila, please can you help me? I have test server, and I inserted lot of rows for test with NOLOCK hint and then i got first error
Msg 9002, Level 17, State 2, Line 1
The transaction log for database 'MCS_BIDB' is full due to 'LOG_BACKUP'.
Then i found this topic and ran this query and I got this errors
Msg 5901, Level 16, State 1, Line 1
One or more recovery units belonging to database 'MCS_BIDB' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure.
Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
Msg 1823, Level 16, State 8, Line 1
A database snapshot cannot be created because it failed to start.
Could not write a checkpoint record in database MCS_BIDB because the log is out of space. Contact the database administrator to truncate the log or allocate more space to the database log files.
Msg 7928, Level 16, State 1, Line 1
The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
Msg 9002, Level 17, State 2, Line 1
The transaction log for database 'MCS_BIDB' is full due to 'LOG_BACKUP'.