Follow by Email

Saturday, 26 November 2016

How to Repair SUSDB

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.

No comments:

Post a Comment