how to restore 2008 backup on 2000 db??

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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