SUSDB SQL Server cannot run " The transaction log for database 'SUSDB' is full due to 'CHECKPOINT' in SUSDB
2. I tried to do DB backup. Failed. I tried to run DBCC CheckDB failed with below error.
-----------------------------------------------------------------------------------------------------------
3. It seems that we have to rebuild transaction logs for SUSDB. We run below scripts to rebuild
-------------------------------------------------------------------------------------------------------------------------
alter database susdb set emergency
go
alter database susdb set single_user with rollback immediate
go
use master
go
alter database susdb Rebuild Log on
(name=susdb_log,filename='D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\susdb_log2.LDF')
go
4. After rebuilding log file. We should run DBCC CheckDB and repair allow data loss.
---------------------------------------------------------------------------------------------------------
alter database susdb set multi_user with rollback immediate
go
alter database susdb set emergency
go
alter database susdb set single_user with rollback immediate
go
dbcc checkdb('susdb', repair_allow_data_loss)
go
Below is DB repairing results. It seems DB has been repaired.
==================================================
DBCC results for 'SUSDB'.
There are 18757 rows in 41 pages for object "tbBundleAll".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'SUSDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
0 Comments