Questions tagged [dbcc]
The dbcc tag has no usage guidance.
10
questions
0
votes
0
answers
512
views
Next step when DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS failes
I'm in a situation where a few Tables of a Database (MSSQL2016 - 13.0.5081.1)
are corrupted (selecting data failes at some point)
There is no valid backup available (the error seems to be present in ...
1
vote
1
answer
2k
views
How to run DBCC CHECKDB when you cannot connect to database?
It appears that I have some file system issue that is preventing me from connecting to MS SQL Express 2008 R2 on my local machine. I receive this message when trying to connect:
Looking over the DBCC ...
1
vote
5
answers
6k
views
DBCC: The database could not be exclusively locked to perform the operation
I run DBCC CHECKDB ([MyDb]) WITH NO_INFOMSGS, ALL_ERRORMSGS, PHYSICAL_ONLY
And after 20 seconds it fails with an error:
Msg 5030, Sev 16, State 12, Line 1 :
The database could not be exclusively
...
0
votes
2
answers
793
views
Dividing DBCC CHECKDB over several days
I'm working on implementing Paul Randal's method of manually spreading DBCC CHECKDB over several days from his excellent article CHECKDB From Every Angle: Consistency Checking Options for a VLDB. In ...
0
votes
2
answers
257
views
If DBCC CheckDB says my database is OK, is it OK?
I'm thinking my way through some disaster recovery scenarios. How does this one sound?
A server running SQL Server 2008 or 2005 suddenly loses power (e.g. the plug gets pulled)
When turned back on, ...
6
votes
4
answers
10k
views
Should I run DBCC checkdb before full backups? Or after?
We have a mix of SQL 2000, 2005, and 2008 servers, and we've always run a DBCC CHECKDB nightly just before the full backups, under the theory that you want to make sure the DB is in good shape before ...
3
votes
1
answer
17k
views
What rights do I need to run DBCC commands?
Do I need to be sysadmin to run DBCC commands on SQL Server? Or is db_owner rights enough?
3
votes
1
answer
3k
views
DBCC CHECKDB fails and quits job, ambiguous error message
I received a notice that one of our servers (SQL Server 2008 Cluster on Win Enterprise 2008 Cluster) DBCC CHECKDB for all databases has been failing the past four times it has been run. We don't have ...
8
votes
2
answers
1k
views
Repairing inconsistent pages in database
We have a SQL 2000 DB. The server crashed due to Raid array failure. Now when we run DBCC CHECKDB, we get an error that there are 27 consistency errors in 9 pages.
When we run DBCC PAGE on these ...
12
votes
4
answers
48k
views
Why is "DbccFilesCompact" status is "Suspended"?
I am running SHRINK file on a 600G data file.
Currently, status is reported as "suspended"
and sys.dm_exec_requests.percent_complete for DbccFilesCompact command reports that it is running (but very ...