Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [dbcc-checkdb]

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.

Filter by
Sorted by
Tagged with
1
vote
1answer
44 views

Integrity checks permissions issue

I am running Hallengren's IntegrityChecks job which fails with the following error: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the ...
3
votes
1answer
75 views

PFS Page corruption issue and question

We recently encountered PFS page corruption in our production DB.  We are in the process of checking old backups to find which ones are clean, but I was wondering if a different process would work to ...
1
vote
2answers
68 views

how to find out how long the last DBCC checkdb took to complete?

In most of my servers I have dbcc checkdb scheduled to run. I can get the last known good DBCC Checkdb through DBCC DBINFO(). I can read the tracks left on the sql server log and I get something ...
8
votes
1answer
172 views

Database Cache Memory in Performance Monitor drops down significantly after DBCC CheckDB

We have been monitoring some SQLServer: Memory Manager's metrics, and noticed that after DBCC CheckDB job, metric Database Cache Memory (KB) drops down significantly. If to be exact, it dropped ...
0
votes
3answers
61 views

MSSQL Mirroring + db integrity check

Is it necessary to do a database integrity check (DBCC check) on mirrored databases? https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/automatic-page-repair-availability-groups-...
2
votes
1answer
68 views

Checkdb issue - Consistency error on two tables at critical database

There was a network activity last night and they were upgrading server switch. Whole network was down and we as a DBA had prepared by disabling all the jobs at DB server for replication and backup ...
0
votes
0answers
28 views

DBCC UPDATEUSAGE versus data inaccuracies [duplicate]

SQL Server 2014 SP2 with Availability groups 3 Node Windows Cluster for AOAG (2 Sync & 1 Async Replicas) NOTE : Databases are with FileStream Enabled Recently we applied Encrypting File System (...
4
votes
2answers
119 views

Failed to allocate BUFs during DBCC CHECKDB

UPDATE 9/12/19 - See my comment below for a status update. I am writing to see if anyone can help me out with a problem that I just can't seem to figure out. This one is going to be a doosey and I am ...
3
votes
2answers
68 views

Distribution database corrupt - What to do?

The below error message has been received from one of our SQL Server databases: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x6847f47b; actual: ...
5
votes
3answers
550 views

DBCC checkdb on tempdb

Is it recommended to run DBCC CheckDB on tempdb? If yes, can someone please list out the reasons to do so? This could be on any SQL Server version. The one I have is SQL Server 2017.
3
votes
1answer
123 views

Unexplainable DBCC CHECKDB Command Output

Microsoft SQL Server 2017 (RTM-CU14-GDR) (KB4494352) - 14.0.3103.1 (X64) Mar 22 2019 22:33:11 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Datacenter ...
1
vote
1answer
90 views

Can a full DBCC CHECKDB operation be safely offloaded to a restored backup on a different server?

We are currently moving towards a 24/7/365 operating model - as such I am investigating our maintenance strategy. One item I'm having trouble in figuring out is DBCC CHECKDB. I have seen numerous ...
13
votes
1answer
514 views

Physical only checkdb is failing, but full one is completed successfully

I am executing checkdb with physical_only option and it fails with multiple errors like below: Msg 8965, Level 16, State 1, Line 1 Table error: Object ID 1557580587, index ID 1, partition ID ...
0
votes
2answers
51 views

Database not going into single_user mode

I have a corrupt database with wrong checksum error. When I try to put database into single_user mode to repair it gives following error. I am using following sql command from management studio to put ...
0
votes
0answers
38 views

CheckDB Failure on most databases in Dev instance

I have a maintenance plan on one of our infrequently used dev boxes which keeps failing on CheckDB on all user databases and most system databases. When trying to run CheckDB manually, I get the ...
1
vote
1answer
169 views

DBCC check on Always On Secondary Replica

What is the best way to schedule DBCC check on all the nodes in Always On availability group. Can we just schedule the same job on all the nodes at the same time including all the secondaries. In my ...
2
votes
0answers
157 views

Errors during CHECKDB

We have a db which reports errors when trying to do a backup: Starting to dig in, the first thing that was suggested was to run DBCC CHECKDB. I've been trying to run that all day now, and googling ...
0
votes
2answers
200 views

DBCC CHECKDB - SQL Log Says Completed, SQL Server Agent Says Failed

I run a nightly Integrity Check (set up via Maintenance Plans) on all of my databases. For the last two nights, the final CHECKDBCC has failed... at least according to the SQL Server Agent Job. ...
1
vote
0answers
227 views

Amazon RDS SQL server and DBCC Checkdb [closed]

New Company and new to Amazon RDS. Several databases have been migrated to the cloud because "everything" is done for us a manager has stated. I have explained standard DBA tasks are still required ...
0
votes
0answers
41 views

CHECKDB run times issue

When using the PHYSICAL_ONLY option and NOINDEX with CHECKDB, my run times are longer! But, on the weekend, it is 1/4 the time without those options. Yes, there are more data changes during the week ...
0
votes
2answers
354 views

DatabaseIntegrityCheck Fails on Large Database Every Day

On one of my databases, the integrity check keeps failing with the error: Connection may have been terminated by the server. [SQLSTATE HY000] Msg 596, Sev 21, State 1: Cannot continue the ...
4
votes
2answers
231 views

Help with wait type CHECK_TABLES_THREAD_BARRIER

I have a 2016 SQL Server freshly built - 13.0.5149.0 - OS 2016 (Microsoft Windows NT 6.3 (14393)). The environment is VMWare. No SQL Server HA configuration. It has a problem where CheckDB "stops" ...
0
votes
1answer
182 views

DatabaseIntegrityCheck fails intermittently

Have been running the Ola Hallengren scripts on our new SQL Server 2016 Enterprise server for about 6 weeks or so now. The database Integrity script only works intermittently on some instances. ...
1
vote
0answers
53 views

Variable Speeds on CHECKDB

Does anyone know why I should experience variable CHECKDB completion times from day to day? I'm seeing times anywhere from 45 to 90min for the task to complete. I am running CHECKDB on 8 SQL Server ...
0
votes
1answer
255 views

sp_MSforeachdb Continue on failure when running DBCC CHECKDB

I have the following maintenance script DECLARE @sql NVARCHAR(30) = 'DBCC CHECKDB(?)' EXEC sp_MSforeachdb @sql This checks every database for corruption. I have run this on my test server where I ...
1
vote
1answer
220 views

MS SQL 2008 Databse in Suspect mode and CHECKDB returns error: Object ID 3 has chain linkage mismatch

We did a disk expansion for VM DB server. However, after this operation the DB became suspect mode and cannot be open. Then we tried somethings like that; https://www.sqlrecoverysoftware.net/blog/...
6
votes
1answer
357 views

DBCC CHECKDB on Always On databases

Do we really need to run DBCC checkdb on a database configured with Always On synchronous updates? I believe the automatic page repair mechanism should identify the corruption and repair it ...
1
vote
0answers
818 views

dbcc failing with Cannot continue the execution because… alwayson having a change of state event for each db

I got a job DatabaseIntegrityCheck - USER_DATABASES, failing with the following error: Date and time: 2018-10-29 02:34:13 Command: DBCC CHECKDB ([one of my databases]) WITH NO_INFOMSGS, ...
1
vote
2answers
573 views

DBCC CheckDb on Secondary Aynchronous Replica

Can I run Ola Hallengren CheckDb job on a Secondary Asynchronous Replica (DR) that is readable during business hours? Currently the Asynchronous Replica is not readable... First question is if it is ...
11
votes
1answer
587 views

Backup detects corruption, but CHECKDB does not

I have a database where when I run the backup command BACKUP DATABASE [MyDatabase] TO DISK = 'G:\Backup\MyDatabase_01_01_2018.bak' WITH NOFORMAT, NOSKIP, COMPRESSION, INIT, BUFFERCOUNT = ...
1
vote
2answers
247 views

Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server

What is Symantec Backup Exec (TM)? I noticed that it is running in one the database server i am maintaining. I am a newbie in db administration and i am not sure what it is. It is running DBCC CheckDB ...
1
vote
1answer
337 views

DBCC CHECKDB fails after restore to SQL Server 2017

I have a DB on SQL Server 2014 and after I restore a backup on SQL Server 2017 I get integrity check errors when running CHECKDB. When I restore it on another machine with SQL Server 2014 it works ...
0
votes
1answer
332 views

Taking Back up on Non readable Secondary Replica Availability group

Is there any way to back up a non readable secondary replica database to restore in a dev environment and then do dbcc checkdb? Will appreciate any help!
16
votes
1answer
489 views

Why is CHECKDB reading the transaction log file on a database with a memory optimized table?

tl;dr: why is CHECKDB reading the transaction log for a user database with memory optimized tables? It appears that CHECKDB is reading the transaction log file of the user database when it's checking ...
0
votes
1answer
1k views

DBCC CHECKDB WITH PHYSICAL_ONLY option runs slower compared to a Full DBCC CHECKDB?

Is it possible for DBCC CHECKDB WITH PHYSICAL_ONLY to run slower compared to a full DBCC CHECKDB? The platform is SQL Server 2014 SP2.
1
vote
1answer
121 views

Filestream directory exists for a partition but the corresponding partition does not exist in the database

I am investigating a high memory usage issue of tempdb on a production SQL Server 2017 Enterprise (64-bit) deployment. This is similar to an issue discussed here. The server has two production DBs ...
15
votes
2answers
288 views

Columnstore Index in read_only filegroup prevents CheckDB

It appears setting a filegroup to read_only prevents dbcc checkdb for the entire database if the filegroup contains a columnstore index. When attempting to run checkdb or checkfilegroup (for any ...
-2
votes
1answer
176 views

DBCC CHECKDB last good date

SQL Server 2014 Standard. Using Ola's (blessings be upon him) scripts to perform database integrity checks: Job command: sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE [dbo].[...
3
votes
2answers
726 views

Getting error running DBCC Checktable(tablename, repair_allow_data_loss)

I ran DBCC CheckDB and got some consistency errors in the database. In an attempt to recover all the data I have exported out all the data from the database to a new database except for one table. ...
0
votes
1answer
808 views

MS SQL DBCC CHECKDB page ID (1:xxx) contains an incorrect page ID

Fistly, yes I'm aware that there are two options 1) is to restore or 2) run DBCC with allow data loss. But I'd like to understand what exactly is corrupted and what possible data loss could be. From ...
0
votes
2answers
304 views

Unable to save and error on DBCC CHECKDB

I try to save my database ≈ 260 Mb I have this error : System.Data.SqlClient.SqlError : failure read function incorrect So I try : DBCC CHECKDB ('myDatabase') PHYSICAL_ONLY I have this error :...
1
vote
0answers
305 views

Why is SQL Server unable to access partitions stored on UNC paths?

I have a database with its primary file and log file stored locally. One table is split into 101 partitions which are stored on a Windows share on another server accessed by a UNC path. Each partition ...
0
votes
1answer
956 views

What can cause DBCC CheckDB to take longer than usual? [closed]

I have a maintenance task, which do a DBCC CHECKDB WITH PHYSICAL_ONLY on the Databases on my server (SQL Server 2016 Standard Edition). This usually takes about 7h30 for about 120 databases and it is ...
4
votes
1answer
246 views

BACKUP WITH CHECKSUM works but DBCC CHECKDB detects problems

A server I administer recently experienced a power outage that caused issues with the SSRS ReportServerTempDB. After the outage, the nightly job that runs Ola's DatabaseIntegriyCheck started reporting ...
1
vote
0answers
154 views

How to verify DBCC CHECKDB

I am logging the DBCC CHECKDB job output to a table. When I look at the job log using the below command, I want to verify that all is well. use msdb EXEC dbo.sp_help_jobsteplog @job_name = N'...
2
votes
3answers
153 views

Dumps after CHECKDB error

I have a little problem with a two-node mirror and customer requirements: There is a maintenance window every night from 01:30 to 03:00, within which I have to run rebuild/reorg and checkdb (...
1
vote
2answers
618 views

CheckDB Operation failing and returning error

We have a database that in the past couple of months has started failing when we run CheckDB on it during the maintenance window. When we re-run it after the failure it will complete fine each time. ...
2
votes
1answer
1k views

DBCC CHECKDB grows tempdb to a huge size - Legacy MS SQL Server 2008 R2 Instance

I have an older Microsoft SQL Server Instance (2008 R2 SU3 GDR - Build: 10.50.6220). When I run DBCC CHECKDB via a Maintenance Plan, the TempDB grows very large. The largest DB on the instance is ...
1
vote
1answer
1k views

DBCC CHECKDB returning space issue error

My database in Production has 28ndf files in different Drives.And on T drive test_audit20.ndf to test_audit23.ndf files only. and file test_audit20 and test_audit21.ndf autogrowth is none. While ...
1
vote
0answers
106 views

Consistency Errors running CHECKDB on a couple of tables in SQL Server 2014 [duplicate]

While running DBCC CHECKDB I am getting consistency errors on a couple of tables in SQL Server 2014. I have tried REPAIR_REBUILD and rebuilding indexes on those tables but these are not helpful to ...