Post reply

SQL 2000 Backup or Tran Logs to SQL 7?

  • October 31, 2002 at 1:08 pm

    #105344

    I have an upgrade issue where the users want to try the application on SQL 2000 in production and if unhappy, go back to SQL 7. They suggested I backup 2000 and restore to 7 and I told them 7 would not recognize a 2000 backup. They then suggested that since both servers came from the same backup, I could apply the 2000 transactions logs to the SQL 7 database. I again told them I don't think that would work. The only thing I can think of is DTS which would take a couple of hours to move a 4 GB db across my network. Any ideas, anyone?

  • October 31, 2002 at 1:17 pm

    #439986

    I think your right on how to track on migrate back. That's what I've done. But I'm not sure I would use your implementation Plan, and allow the customer to fallback given any little problem they might find.

    Here is what I would suggest as a plan for migrating:

    0) Build a 2000 testing environment

    1) Backup 7.0 Production

    2) Move 7.0 database to a 2000 server for testing ONLY purpose.

    3) Have the users bang away on 2000, letting them know that this is only a test, and all transaction will be lost.

    4) If testing goes good and customers are happy with SQL 2000, proceed. If not resolve issues and start again at step 0 or 1.

    5) Backup 7.0 Database

    6) Migrate 7.0 database to 2000 for REAL.

    Now hopefully if you get to step 6, most likely you will not need to go back, but if you do, your customer know it will take time to migrate back. Make sure the customer do a good test prior to going to step 5.

    Hope this helps.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • October 31, 2002 at 2:34 pm

    #439988

    That's was my plan. Until they decided to consolidate 3 SQL 7 database on one 2000 box and then put it in production. So now I'm scrambling to get another test box set up and do the testing right rather than this rush to get everything done before year end and short cut all the individual and joint testing. Fun fun fun.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply