Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
beppe_30
Starting Member
5 Posts |
 Posted - 2010-06-17 : 05:41:36
|
| We are in the process of migrate our SQL Server 2K to a new box with SQL Server 2008.We intend to move our database to the new box/sql instance 2008 with restore.We know that the option "Page Verify" remain the same when we restore our db to the new SQL instance.But we also know that there is a new database option, which is "checksum".First question:Do we need to modify this option which is set to "none" or "Torn_Page_Detection" to "checksum"?Second question:If we modify our databases with the "checksum" option, do we also need to execute the backup with the error management option "with checksum"?Can you please explain what is the best or recommended approach?Thank you very much for your time.Kind regards.beppe_30 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-17 : 06:54:14
|
| Some thoughts on migrating to SQL2008 here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230I agree with the posts in the linked thread. Since moving to SQL2008 we have turned on Checksum on all databases, and on Backups (we have the continue-after-error on the backups too (i.e. if the database checksum is wrong during backup) so we do at least get a backup file, even if after restoring it we will still have to deal with the errors. |
 |
|
|
beppe_30
Starting Member
5 Posts |
Posted - 2010-06-18 : 03:20:36
|
Kristen, thank you very much for the interesting link. beppe_30 |
|
|
|
|
|
|
Page verify - Backup with checksum