Checks the logical and physical integrity of all the objects in the specified database. Should be used to identify pages marked as suspect so they can be restored from backup or otherwise fixed.

learn more… | top users | synonyms

3
votes
2answers
45 views

Historical dbcc checkdb results

Is there a better way of accessing historical dbcc checkdb result history (if output logging was not used at runtime) than xp_readErrorLog? EXEC xp_readErrorLog {0-20}, 1, N'CHECKDB'; SQL Server ...
4
votes
3answers
122 views

check when last backup was taken

Brent Ozar had an interesing newsletter on 2015-06-22; How do you manage dbas measuring backups, where he thinks that a good DBA should check when the last backup was done it was last restored ...
4
votes
1answer
56 views

Understanding DBCC CHECKDB, Snapshots, and SQL Server Standard Edition

Understanding the circumstances under which SQL Server creates a snapshot when running CHECKDB, I followed a link to this KB that states: Database snapshots are available only in SQL Server ...
1
vote
1answer
50 views

CheckDB error 9003 SQL server 2014

Currently I am restoring SAN snapshots to another server nightly and running weekly checkdbs on that test server. The checkdb is throwing the following errors. The log scan number (105217:402:0) ...
2
votes
1answer
204 views

Can I backup (Full) the Log-Shipping Secondary Database?

I have a Highly pressured Production Environment with Database name DB1. And I want to run a weekly DBCC CHECKDB process on one of the databases there. (You can understand,I can't do it on my ...
1
vote
1answer
66 views

Possible to restore a damaged database's PRIMARY filegroup only?

I have a database (MyDatabase) with 2 filegroups, [PRIMARY] and [SECONDARY]. The [SECONDARY] filegroup has 2 datafiles, [DataFileA] and [DataFileB]. [DataFileA] is damaged (even after DBCC CHECKDB ...
2
votes
1answer
212 views

The operating system returned error 665(The requested operation could not be completed due to a file system limitation) on SQL Server 2014

Have a SQL Server 2014 instance running on Windows 2012 R2 that was running Ola Hallengren's DB integrity script. This is the error that resulted: The operating system returned error 665(The ...
4
votes
1answer
95 views

Long running DBCC CHECKDB

I am on SQL 2014 Standard doing offline DBCC CHECKDBs (so on a box other than production). For the most part, my process is going pretty quick but for some reason I have this small DB (6gbs) and its ...
3
votes
0answers
94 views

Database corrupt after restore and upgrade on another instance

Just wondering, if someone faced the same issue. We have got a SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) and there is a process of backup on MSSQL Server 2008 R2 and restore on ...
2
votes
1answer
509 views

CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object

Msg 8906, Level 16, State 1, Line 1 Page (1:99122) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:97056), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'. ...
2
votes
1answer
1k views

SQL Server: Invalid Log Scan Number (…) passed to log scan in database (…) is not valid

We are getting a large number of the below errors on one of our production databases. CheckDB is completely clean. We thought it was related to replication so we shut it down using ...
5
votes
2answers
2k views

How to repair database consistency errors

I have a Microsoft Dynamics AX SQL Server database. I just run DBCC CHECKDB in order to check the integrity. After a few minutes I got at the end of the results the following: CHECKDB found 0 ...
0
votes
1answer
135 views

Orig DB = No Corruption, Backup/restore = Corruption?

We are setting up offline DBCC checkdbs on an offline server so we can still do our checks, but not interfere with production. When we backup the Master DB and restore it (even directly on a local ...
3
votes
1answer
54 views

Suspect (Torn) Pages recorded in TEMPDB? (SQL Server 2005 SP3)

I have a virtualised SQL Server 2005 (SP3) server that reported the following msg: Database_Name, Database_Id, File_Id, Event_Type, Event_Type_Desc, Error_Count, Last_Update_Date tempdb, 2, 1, 3, ...
2
votes
1answer
186 views

TempDB not selectable for DBCC maintenance plan

I'm trying to clean up some of our maintenance plans and noticed that our TempDB is not getting it's weekly dose of DBCC CHECKDB goodness. I've tried to go into the maintenance plan and make sure ...
1
vote
1answer
529 views

“Could not insert a backup or restore history/detail record in the msdb database” While restoring msdb

Today I found msdb database was in suspected mode, so I restored MSDB from my latest backup(As I have daily backup for this database). When I restore the MSDB database using Tsql i got below errors, ...
1
vote
0answers
66 views

Integrity checks on large dbs (700GB)

What's the best strategy for integrity checks on large dbs? DBCC CHECKDB (DB Name) would probably take over 24 hours, the largest table (532GB) would probably take over 17 hours...
2
votes
2answers
618 views

CHECKDB fails on MSDB and Master system databases

I get the following error within my maintenance plans: Executing the query "DBCC CHECKDB(N'master') WITH NO_INFOMSGS " failed with the following error: "The database could not be exclusively ...
2
votes
0answers
576 views

DBCC CHECKDB reports torn page. How do I find what is in the torn page?

Using SQL Server 2005 I get the following error when running DBCC CHECKDB SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual ...
1
vote
1answer
3k views

The operating system returned error 665(The requested operation could not be completed due to a file system limitation)

Have a SQL Server 2014 instance running on Windows 2012 R2 that weekly runs Ola Hallengren's DB integrity scripts and the last two weeks started getting this error: DESCRIPTION: The operating ...
1
vote
1answer
1k views

How can I correct SQL Server Error 8928?

I received the following error message in an application running against one of my databases: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xfdff74c9; ...
1
vote
0answers
215 views

DBCC TABLE CHECK seems to hang

Our nightly maintenance plan includes a database integrity check which normally takes 45 minutes to complete. Now it appears to hang. When looking at the Activity Monitor, a series of process items ...
1
vote
0answers
2k views

Possible schema corruption. Run DBCC CHECKCATALOG

Good Evening to all. I was working with sql server 2008. Thing i did: Actually i was noticed that the free space available in C drive reaches below 1 GB .So i thought to Club the D drive with C ...
1
vote
0answers
199 views

CHECKDB Allocation Errors Msg 2576, could not repair, object id does not exist

I inherited a database that has no value in LastKnownGood. I ran repair allow data loss, says it was successfully repaired, but no change to the errors when I run checkdb again. In case it was a SQL ...
1
vote
0answers
318 views

SQL command in stored procedure continue on error

To perform Checkdb on all database of server i am using a stored procedure which loops over a view which contains list of databases in server and the stored procedure performs checkdb on all databases ...
2
votes
1answer
576 views

Checkdb giving error for master database

When i run dbcc checkdb on master database i get error like 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, ...
1
vote
0answers
266 views

SQL Error 3183 on SQL Server 2012

I have a backup of database version SQL Server 2008 R2. While restoring it to SQL Server 2012 I am getting error: msg 3183 RESTORE detected an error on page (6100:1886858449) in database ... . ...
0
votes
1answer
502 views

dbcc checktable/checkdatabase errors after database restore

Following on from this question Error when creating an index in SQL Server 2012 we have been having problems restoring our live database back to test. Our current production database is SQL 2005 ...
2
votes
1answer
396 views

DBCC CHECKDB ERROR Msg 8992

I have got the Following Error When i ran the checkDB over the database. What are the steps can be taken to resolve the issue. Without affecting the users. Msg 8992, Level 16, State 1, Line 2 Check ...
5
votes
2answers
1k views

Dividing DBCC CHECKDB over multiple days

I'm working on implementing Paul Randal's method of manually spreading DBCC CHECKDB over several days for very large databases, which basically consists of: Dividing the tables in the database ...
1
vote
0answers
406 views

DBCC Physical only giving Connection failure

I have a SQL server 2012 Ent DB. The hosting company is trying to setup new backup solution using Symantec Backup Exec. They have come back and said our database is corrupt because they get these ...
11
votes
2answers
987 views

DBCC CHECKDB unfixable corruption: Indexed view contains rows that were not produced by the view definition

TL;DR: I've got an unfixable corruption in an indexed view. Here the details: Running DBCC CHECKDB([DbName]) WITH EXTENDED_LOGICAL_CHECKS, DATA_PURITY, NO_INFOMSGS, ALL_ERRORMSGS on one of my ...
3
votes
3answers
787 views

Which system databases should I checkdb and defrag indices?

I have SQL Server Agent (2005) jobs that periodically perform CHECKDB and a defrag (ALTER INDEX REORGANIZE/REBUILD) of any index that is highly fragmented. These are typical maintenance best ...
4
votes
3answers
2k views

DBCC CHECKDB Notification

There are plenty of questions on DBA.SE regarding DBCC CHECKDB and how to resolve problems when errors are returned. My specific question is on actually getting notified that DBCC CHECKDB returned ...
3
votes
1answer
2k views

SQL Server 2008R2 DBCC CheckDB never finishing

I'm running SQL Server 2008 R2 on Windows server 2008 R2 and up until recently we were having no problems. After windows updates recently (no sql server updates) we cannot run step 1 of our ...
7
votes
2answers
4k views

How might a corrupt partition in TempDB result in DBCC CHECKDB reporting no issue?

One of our SQL Servers reported the following error recently: DATE/TIME: 2/25/2013 9:15:14 PM DESCRIPTION: No catalog entry found for partition ID 9079262474267394048 in database 2. The ...