Why did you detach the database and delete the transaction log? That's not going to fix the corruption. See this post on why trashing your log is not good http://www.sqlskills.com/blogs/paul/2007/09/15/CorruptionLastResortsThatPeopleTryFirst.aspx

sp_resetstatus...

DINESH (3/11/2008)

---

to recover data from suspected database do the following

1. open master database

2. open table sysdatabases

3. change the 'status' value of ur database to 32768

4. refresh the sql server

5....

pmohan (3/4/2008)

---

How r u trying to reduce the size? If the database is in full recovery mode you cannot reduce the size without taking a log backup or full backup.Once...

🙂 I tend to get a little riled when people post links that aren't terribly useful or pertinent. Many people (I'm not saying it's the case this time) just post...

This isn't a SQL Server error message - it's a message from Microsoft Dynamics. I recommend you post this (but post a *link* to your bitmap, not the actual bitmap)...

That would be a bit useful if they were on SS2000, but they're not. Please check which forum you're in before posting inappropriate links - thanks!

I don't recall any issues in index rebuild that could show this - but it's possible there was one with parallel index rebuild plans. It could also be a stale...

No - it will never show differently than what it logs - both outputs are driven from the same set of zero-or-more errors.

It could be that something went wrong between...

What was the sequence of events here - what time did the index rebuild job fail and what time was the CHECKDB start and finish?

Sean - having tempdb on the same array as the user DBs is going to be a problem, and not just for CHECKDB. For CHECKDB, it's going to be reading...

Sean - no, the switch is called DBCC CHECKDB 🙂 - it does a CHECKALLOC and then batches of CHECKTABLES in parallel. Sounds like its the 64bit limitation on Standard...

It's really more to do with the number of data files in the database being checked - the way I wrote the read-ahead algorithm in CHECKDB was based on...

Stanislas,

When you say that it 'failed' - what exactly do you mean? It seemed to hang? It complained that it didn't have enough disk space? Or some other error?

Your tempdb...

One solution that I recommend as a way for customers to offload the CPU and IO workload of CHECKDB from production servers is to restore your backups on another system...

Not that CHECKDB gets itself in a loop, just that because it effectively cycles the buffer pool and uses lots of memory, it could cause lots of paging depending on...