Hmm - I don't see anything at all harsh in what I said - hi - please- thanks.

What are you taking as harsh Robert? I believe you're mistaking directness...

823s are always caused by a problem in the IO subsystem - something underneath SQL Server. I've never seen a case of a SQL Server 2000 corruption causing an...

Don't drop the databases - the restore may fail and then you're left with nothing. Restore to a different database name in case there are problems with the backups.

Yes, of...

A reboot isn't going to fix anything - these are corruptions in the database files on disk. The only way for you to repair without losing data is to restore...

Both the right answer and the explanation of the right answer are technically incorrect here.

See http://www.sqlskills.com/blogs/paul/2007/10/04/InsideTheStorageEngineIAMPagesIAMChainsAndAllocationUnits.aspx for the correct explanation.

Thanks

Absolutely agree.

If you don't want point-in-time recovery, don't use the FULL recovery mode - you don't get any other gain from using FULL. In that case, just use SIMPLE.

If you...

oh - I didn't mean those were the only things that could cause fragmentation. Insert and deletes will cause fragmentation too, depending on their pattern and position within the index.

As...

Hmm - dropping the table is the fastest way as it logs the least and doesn't take any locks, compared to truncate table. I think that was a bad question...

Here are some quick tips for you:

- reorganizing an index will never update stats - the operation doesn't have a complete view of the index so can't update stats....

It depends how many rows you're deleting and whether you've changed the default lock escalation behavior with any trace flags. The default threshold for when escalation can occur (not guaranteed...

Can you set one of the user DBs to not auto-close and then run CHECKDB on it twice? I want to see if it succeeds or not.

I haven't run CHECKDB on SQL Express for a long time so just for my peace-of-mind I ran CHECKDB on master, model, and msdb on an Express instance - it...

And just to be sure, you could successfully run CHECKDB on master, model, msdb the day before? No crashes?

Are the user databases set to auto-close?

The only thing I can think of is that something crashed and caused a hidden snapshot to stay around. In that case another hidden snapshot cannot be created. If this...

How much free space is there on the drive where the database is stored?

Did you move the databases at all?

Something has to have changed between when it worked and when...