My guess is that the perf drop is because the buffer pool and procedure cache went cold - i.e. everything that was resident in them from a steady-state workload was...

I believe you need to use the conv65 utility to convert to the 7.0+ format - you can't do that from a backup, and you can't restore a 6.5 backup...

Cool - you've had different aggregated experiences from me, hence our disagreement in the percentages. I tend to deal with very high-volume VLDBs with well-written code where hardware usually is...

Jeff Moden (2/13/2008)

---

Heh... There's always a way to fix the code... That's because if you have a performance problem, it will stand a 90% chance of being a code...

You've got a corrupt page in the master database. Looks like the page has been zeroed out by something in the IO subsystem (most likely your hardware).

Master is critical for...

Do you mean the 2005 installation is gone, or that it won't start up? (i.e. define 'gone down')

The IO subsystem corrupted your database when the machine crashed. Error 824 is that a page checksum failure occured - a page's contents were altered AFTER it had been written...

Why didn't you just restore the 2005 backup on the 2005 server and continue from there? why take the data back to 2000 and then try to move forward to...

Your database is corrupt. You need to restore from your backups (or failing that, run repair).

Are you running regular DBCC CHECKDBs and this just occured, or is this a one-off...

No worries - everyone has to learn sometime.

Could be your connection settings.

See http://support.microsoft.com/kb/169377 for instance.

I think this should be in the general forum rather than data corruption.

ok - that's the issue then. I don't know off the top of my head - I don't believe that you can control it without rolling your own log shipping....

Could it be using universal time for the timestamp? What timezone are you in - GMT+/- how much? My guess is you're in India (IST) which is GMT + 5h30.

Btw - if you're trying to extract data from the nodes within the XML BLOB, check out the nodes(), query(), value() XML functions too in BOL.

You can define primary and secondary indexes on an XML column in the table. A primary XML index is the same as a clustered index. A secondary XML index is...