One other thing - is the system *really* busy while the shirnk is going on? Are the disk queue lengths really long? This could be an IO that never completes...

It looks like you're usking SQL Server 2000 - I changed that message in SS2005 to say 'Unable to' instead of 'Could not'.

Which build of SS2000 are you using? There...

Yeah, I should have added what happycat59 said - mine was just the 'wow' quick response 🙂

Thanks

You shrink your database every time you're going to do a backup? That's going to cause horrible fragmentation issues with your indexes.

Checkout a series of articles I wrote last year and this year when I was still in MS about running CHECKDB - http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC+CHECKDB+Series/default.aspx

There's also a recording of a session I...

Can you try doing a select * from each of the named tables? My guess is that the text error you previously had is from a row in sysindexes -...

ok - so you're running SQL Server 2000 (from the error message you posted).

Is that the only output from CHECKDB? There should be some more specific errors too?

What's the exact error message you're getting?

Also I recommend changing your ETL process so that it happens in batches - then you can avoid having the log grow so much whenever the process runs. Depending on...

Gift Peddie has it right. C, C++, C# and a tiny amount of assembly. The vast majority is C++.

It could be your AV software - I've seen it do weird things before.

Can you post the output from "dbcc checkdb (yourdb) with all_errormsgs, no_infomsgs"?

Hi,

Your question is a little unclear. Are you asking whether you should restore your full backup as a different database once the backup has completed? If so, yes, that's a...

Can the client machine ping the server machine?

Why not just create a script to rebuild the index you're interested in and setup a weekly Agent job to run the script?

No - and it doesn't look like the functionality made it into SQL Server 2008 either. It is on the to-do list for the AS team.