Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.1k views
in Technique[技术] by (71.8m points)

sql - CHECKDB found 0 allocation errors and 218 consistency errors in table 'MyDatabase' (object ID 1509580416)

My database was unexpectedly went into suspect mode. After analyzing I found that this is because of the log issue. So, I rebuild the log once again. After rebuilding the log file, I ran the SQL command DBCC CHECKDB(MYDATATBASE).

It throws some errors so I tried to repair the database by using the following command

DBCC CHECKDB (MYDATATBASE, REPAIR_ALLOW_DATA_LOSS) 
WITH NO_INFOMSGS, ALL_ERRORMSGS;

The above command executed with the below following errors:

CHECKDB found 0 allocation errors and 218 consistency errors in table 'MYDATATBASE' (object ID 1509580416).

CHECKDB found 0 allocation errors and 1625 consistency errors in database 'CORRESPONDENCE'.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share

2.1m questions

2.1m answers

63 comments

56.6k users

...