The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
583 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 ...
1
vote
5answers
2k 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 ...
0
votes
2answers
252 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
2answers
168 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, ...
5
votes
4answers
4k 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 ...
1
vote
1answer
2k 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
1answer
1k 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
2answers
319 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 ...
4
votes
2answers
11k 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 ...