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.
177
questions
0
votes
1
answer
28
views
Is DBCC CHECKFILEGROUP worthless if you already run DBCC CHECKDB on all databases?
DBCC CHECKDB makes many other integrity checks redundant, but I can't see anything in the documentation saying if it makes DBCC CHECKFILEGROUP redundant. Is DBCC CHECKFILEGROUP worthless if you ...
4
votes
1
answer
109
views
Backups/CHECKDB errors - "Cannot find server certificate"
I have been exchanging TDE certificates on various servers to make restores easier - some had the wrong name, the wrong thumbprint, or even both. This involves transferring databases to a temporary ...
0
votes
0
answers
67
views
Backup database in SQL Server 2012 and restore this backup in SQL Server 2014
First what I do is to check consistency of database in SQL Server 2012:
CHECKDB (DATABASE1)
And it is ok, no errors and warnings.
Next I do FULL backup and restore it on another machine with has SQL ...
1
vote
2
answers
72
views
My backup failed DBCC CHECKDB. Now what?
Assume the following:
I have a database on a production server. I do not regularly run DBCC CHECKDB on it.
I regularly take full, dif, and transaction log backups on my database.
As is good practice, ...
1
vote
1
answer
107
views
DBCC CHECKDB WITH EXTENDED_LOGICAL_CHECKS fails when run on Secondary replica
Create the simplest database possible:
CREATE DATABASE DatabaseCheck
Add this database to an Availability Group, where secondary is not readable
On primary run:
DBCC CHECKDB ('DatabaseCheck') WITH ...
0
votes
1
answer
127
views
Whether to run integrity check before or after backups (Ola H FAQ)?
Going through Ola H FAQ's, https://ola.hallengren.com/frequently-asked-questions.html, I see that
I also recommend that you perform the full backup after the integrity
check.
Isn't the opposite true?...
0
votes
1
answer
508
views
No catalog entry found for partition ID in database 7
I would like some help to fix the database problem.
I went to restore a database and I couldn't, so I executed DBCC CHECKDB (N'DATABASE_NAME') and the following result is displayed:
CHECKDB found 0 ...
-2
votes
1
answer
347
views
Database Integrity check fails as follows
(I have used the Ola Hallengren scripts for quite a while)....but if there is an open query I end up with the following:
Msg 5030, Sev 16, State 12, Line 1 : The database could not be exclusively ...
0
votes
1
answer
66
views
What is the table design for DBCC History of the command DBCC CheckDB on SQL Server 2019
I cannot find anything other than a SQL Server 2017 table structure which lists [RepairLevel] as an int, which in SQL Server 2019 it isn't, it's a string of sorts, if I set it to varchar(7000), the ...
1
vote
2
answers
941
views
Foreign key constraint not showing in sysobjects but cannot be created due to conflict with itself
I have an Microsoft SQL Server 2019 Enterprise Edition database where I had a relationship between two tables: Properties and Photos with Properties being the primary key and Photos being the foreign ...
4
votes
1
answer
272
views
Do I really need a backup when using REPAIR_ALLOW_DATA_LOSS?
Reluctant DBA here.
Do I really need a backup when using REPAIR_ALLOW_DATA_LOSS? I am well aware MS recommends doing a backup.
What's the worse that could happen if I run a DBCC CHECKTABLE using ...
1
vote
0
answers
102
views
There are Suspect Pages but DBCC CHECKDB returned no errors?
As the question states, there are 3 suspect pages on a database, but when I ran DBCC CHECKDB (DB, REPIAR_REBUILD), after almost 4 hours, it completed with no errors. I know suspect pages might not ...
0
votes
0
answers
122
views
Corruption in backup but valid checksum
We have corruption in one of our full backups but I can't find an explanation how it happened. The server is a SQL Server 2019 Enterprise edition (CU17) with 5 databases in an AG. The backups are ...
1
vote
0
answers
78
views
What is the way to handle corruption in db having simple recovery model?
A database in simple recovery model cannot have log backups.
In this situation what is the way to handle corruptions reported by dbcc checkdb without data loss?
The documentation says:
Use the REPAIR ...
3
votes
1
answer
121
views
Formula for memory grant for DBCC CHECKDB
How is the memory grant for a DBCC checkdb determined (other than the max size for memory grants which is from resource governor, possibly the default pool)?
I'm not trying to solve a specific problem....