Skip to Content

DB Copy from SQL2000(32bit) to SQL2005(64 bit) using transaction logs

Good afternoon,

I want to make a homogeneous system copy of my PRD R/3 4.7 Enterprise from a WIN2003 (32bit) MSCS Cluster and MSSQL2000 to a new hardware running WIN2003 (64bit) MSCS cluster and MSSQL2005.

As my company works 7X24, in order to minimize downtime, I plan to make an initial database copy using a PRD daily backup, tunne and check my system performance, and then some days later when I'm sure that everything is working fine, make another database copy using the MSSQL database tools. I plan to make final this copy using the following steps:

- initial restore of the source database backup in the new system, keeping the old system online.

- shut down source system.

- backup transaction logs.

- restore this transaction logs on the destination system.

- perform the pos-database copy actions, and go live with the new system.

This method allows me to copy my 500GB with a downtime of minutes.

- Is this a "SAP supported scenario" ?

- may I restore transaction logs of a MSSQL2000(32bit) DB on a SQL2005(64bit) SD Server?

I would like to have your opinion about this possible scenario. I tryed it on my "Quality System", and it seems to work fine, but there are a lot of migrations in this process, that I may be forgetting something:

- Upgrade WIN2003 from 32 to 64 bit

- Upgrade SQL from 2000 (32bit) to 2005(64bit)

- Upgrade R/3 kernel from 32 to 64 bit

Also this is a cluster...

Thank you by your feedback.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 11, 2009 at 08:40 PM

    Hello my friend

    Actually it's not fair to call it a homogeneous system copy, because it's not that smooth and will be quite complicated 😊

    The 64bit you mentioned, is it x64 or IA64? I had one similar about upgrading from 46D to 7.0, 32bit to x64 and SQL 2000 to 2005, so I assume this case is happening on x64. For that, you cannot directly restore a SQL 2000 32bit database to SQL 2005 x64, which is not supported for SAP system upgrade.

    Generally, it should be divided into 4 steps:

    1. Fresh install SQL 2000 32bit on Win2003 x64

    2. Restore a database copy of your source system by detach/attach method

    3. Upgrade SQL 2000 32bit to SQL 2005 32bit

    4. Convert SQL 2005 32bit to x64 (for 7.0 it requires STM tool, 4.7 version I'm not sure)

    Let me know whether this scenario matches your case and discuss more.

    Thanks,

    Effan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      you have to convert the collation to BIN2 BEFORE you go to SQL 2005. If you miss this, you have to do a homogenous systemcopy with r3load to get the collation fixed. And this is something you might want to avoid.

      Best regards

      Clas

  • avatar image
    Former Member
    Mar 11, 2009 at 08:42 PM

    BTW, I don't think you can upgrade Win2003 32bit directly to whichever 64bit version. You probably need a new installation of Win2003 x64 and migrate applications.

    Effan

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 25, 2009 at 10:29 AM

    I already restore a SQL2000 on SQL2005 in my test system with no problem. I plan now to restore the database "leaving it offline but able to restore aditional transaction logs" and then restore aditional transaction logs, after shutting down the R3 server. Is this a problem?

    Also I'm using MS DPM (Data protection manager) to protect my SQL2000 database. May I use DPM to restore this database on a SQL2005 target Server?

    Thank you

    Add comment
    10|10000 characters needed characters exceeded