dbasql79 (8/1/2012)
2000 would use Torn_page_detection to check IO level corruption. Better change it to Checksum.
+1
Do this before rebuilding the indexes - IIRC, checksums are only written when the data/index page is updated.
Rebuilding the indexes should ensure checksums are created for all your data.
I'd recommend setting Compressed Backups as the default & switch on 'Optimise for Ad Hoc Workloads' option, but they're not really upgrade considerations 🙂
Have you run the Upgrade Advisor to check your SQL is compat-90 valid? Or is that the application vendor's problem?
Cheers