March 27, 2012 at 8:23 am
hi..
i like to know if i upgrade sql sever 2000 db to 2008 db and after 10 days if developers had problem with compatibility or other and my client asked to restore the 10 days data updates to previous 2000 db (where it is available as backups(full and transactional).
how to do it?
thanks
March 27, 2012 at 8:39 am
Can't be done. Databases cannot be downgraded in version.
Best bet here, keep a backup of the 2000 database from just before the upgrade and if you have to go back use something like RedGate's SQLDataCompare to sync the data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 27, 2012 at 10:04 am
s1123 (3/27/2012)
hi..i like to know if i upgrade sql sever 2000 db to 2008 db and after 10 days if developers had problem with compatibility or other and my client asked to restore the 10 days data updates to previous 2000 db (where it is available as backups(full and transactional).
how to do it?
thanks
Is this the production server you wish to upgrade?
If so, surely you should be doing some development/QA testing prior to the upgrade? Can you upgrade the test environment first and have the developers work with it for a few weeks if you dont have a QA team? Have you ran the upgrade advisor?
One thing I have done in the past with a restricted budget is to build the new server and restored a backup for adhoc testing of applications.
Trying to roll back up to 10 days after migration is going to be messy. Especially if there is a lot of data to compare.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply