Questions tagged [dbcc]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
Cadburry's user avatar
  • 111
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 ...
user avatar
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 ...
user46529's user avatar
  • 137
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 ...
BradC's user avatar
  • 2,210
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, ...
codeulike's user avatar
  • 1,008
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 ...
BradC's user avatar
  • 2,210
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?
atricapilla's user avatar
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 ...
Ddono25's user avatar
  • 165
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 ...
user avatar
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 ...
dance2die's user avatar
  • 2,031