Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [checkdb]

9 questions
6
votes
3 answers

How long should I expect CheckDB with REPAIR_ALLOW_DATA_LOSS to run

I am running CheckDB with REPAIR_ALLOW_DATA_LOSS on a Shairpoint search DB that is 47mb It has been running for > 30min. Is that normal? How long should it take?
Sruly
  • 183
  • 1
  • 4
  • 6
6
votes
4 answers

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 you back it up. (Obviously, full verification of…
BradC
  • 2,220
  • 4
  • 27
  • 36
2
votes
2 answers

SQL server 2005 Checkdb - no room for snapshot files

I have a 2Tb+ SAP database with 8 datafiles, the first files have grown to fill the available disk space on our HP EVA5000, and the growth is now on the new files. We upgraded SQL from SQL server 2000 to 2005 and Checkdb works differently, and now…
user16479
1
vote
2 answers

Killing DBCC CheckDB when storage blips

The controllers on one of my cluster's SAN's are periodically restarting themselves. Apparently it can be fixed by a firmware update, but until we can apply the update in a few days, I have to live with the issue. The problem is, if one of them…
Aaron Alton
  • 1,138
  • 11
  • 10
1
vote
2 answers

SQL Server : CheckDB runs fast enough on one database, agonizingly slow on another

This one's for you, Paul! :-) I have a customer which has two databases for two of his office locations. Both are roughly the same size (around 10 GB), both are hosted at the same professional hoster's site - so give or take, they're the same. Yet,…
marc_s
  • 1,152
  • 4
  • 21
  • 35
1
vote
1 answer

SqlServer 2008R2 sp1 CHECKDB crashes when spatial index present

We've been having an issue with DBCC CHECKDB crashing with an access violation (null pointer deference) on Sql Server 2008R2 when spatial indexes are present. It is repeatable with DBCC CHECKDB WITH EXTENDED_LOGICAL_CHECKS but also happens in some…
Michael Ferrante
  • 1,641
  • 1
  • 13
  • 10
1
vote
2 answers

is there a GOTCHA - DBCC CHECKDB ('DBNAME', NOINDEX)?

I am turning on DBCC CHECKDB in our OLTP environment (SQL 2005,2008). System overhead is a very visible thing on our serversso I want them to be as efficient as it makes sense for them to be. HENCE - I want to turn on the NOINDEX option, an option…
Deb Anderson
  • 11
  • 2
0
votes
1 answer

How to run DBCC CHECKDB with both REPAIR_ALLOW_DATA_LOSS and NOINDEX

I have a very large database (233GB), and running DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS is taking WAY too long (over 15 hours). There are a lot of indexes on a table that I would rather have removed, but cannot remove the table until the database…
Walter Zydhek
  • 101
0
votes
2 answers

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 short, the strategy consists of: Divide the…
BradC
  • 2,220
  • 4
  • 27
  • 36