Simple answer - no. You need to attach the database and then run repair (as you don't have a backup). Are you having problems attaching the database?

A torn-page is basically...

You can't interrupt a query that's rolling back. You have two options:

1) change the query so it doesn't 'crash'. What do you mean by that?

2) break up the operation into...

Be careful. As with all such software, it can only *try* to repair...

Hi Carl,

The pages and extents that are deallocated by the TRUNCATE are locked until the transaction commits or rolls back so that no other transaction can allocate and overwrite them....

Hi Steve,

This is a corrupt page at the leaf-level of the clustered index for sysindexes. It's not repairable by DBCC (or any other documented or undocumented means). The only options...

I'm intrigued - can you post the T-SQL you're using? I'm not a stats expert but I can probably get Kimberly to take a look.

Yes, if you're doing index rebuilds...

No problem.

Nope - what I posted is what I would do in this situation.

Thanks

You need to use T3604, not T3406.

The data in the repaired database will not be available. The page that had the 823 error cannot be read by the operating system...

Well, you've certainly got some IO susbsystem-caused corruption in there. You could *try* rebuilding the clustered index on the COSP table to fix some of the problems, but the rest...

You need to post the complete output before I can tell you what the problems are - then it *may* be possible to get around the problems without running repair....

Pretty simple:

Header corruptions (and all other types of page corruption) are almost always caused by IO subsystem issues.

The best ways to prepare are:

1) have a sound backup strategy

2) if need...

Nope - you can only trap the last error returned. Same with corruption errors reported by CHCEKDB.

Hi Ali,

You do need to run DBCC CHECKDB. Beware that even if CHECKDB finds corruptions, it will complete successfully, Depending on how your maintenance job is setup, you may miss...

"data is very more important than structure."

Absolutely - so if you have important data then you should have a sound backup strategy and even a redundant mirror of the data....

Sigh - no, I'm not wrong. If an MDF's file header is corrupt, it nearly always means that a lot of the rest of the database has corruptions too. No...