Skip to Content
avatar image
Former Member

mssql 2005 migrate to mmssql 2008r2

This is my first post here so bare with me.

I have a sandbox system abab/java running on win server 2008 r2.

This is a Distributed system dabase running on another host with sql 2005.

I would like to migrade the database to a new host sql 2008 r2 with backup/restore.

I´m looking for a guide for this, i know i need to use SWPM but i´m not sure where to find the option for restore/attach database.

Vidar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 10, 2013 at 10:23 AM

    You're right Vidar.  It's not very clear at all.

    Here's how I did it (although I used backup/restore to minimise downtime):

    - Shutdown source SAP system.

    - Create the DB directory locations on the target server.

    - Ensure that you can logon with the <sid>adm user to the target server.

    - Shutdown source DB.

    - Detach source DB.

    - Copy source DB files to target server.

    - Attach source DB to target SQL Server instance (usual method).

    - Launch SWPM (you will only need the 7.20 UC and NUC kernel parts, you do not need the SL controllers for this work).

    - Go into the SWPM, MS SQL specific section, target DB and select post-system copy.

    - The SWPM will run some checks, re-name the schema if it needs to (you don't need it), run some ABAP reports.

    - At the end of the SWPM process, you continue with the post-system copy steps from the standard SAP document.

    Easy.

    Message was edited by: Darryl Griffiths, more specific text.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vioar,

      Glad you've got it all working.

      When you say "job" do you mean background job (visible in SM37) ?

      If you do, you need to search for background jobs that are configured to run on a specific application server by checking the settings of background jobs in table TBTCP using fields XPGTGTSYS and XPGRFCDEST.

      You may find that some of the jobs have been designated to run on the old server.

      If you mean TP, then it could be that TP is picking up an environment variable from somewhere, which tells it the DB hostname.

      Darryl

  • avatar image
    Former Member
    Oct 08, 2013 at 10:58 AM

    Hello,

    You can use system copy guide for this. Please download system copy guide from http://service.sap.com/instguides.

    Please also refer to SAP note 151603.

    Thanks,

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2013 at 12:06 PM

    Hi

    I woulde like to know the steps  after the database is in place , what are the steps to configure the system so it knows about the new databse host.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Clas Hortien

      what I found in the swpm was "

          You do not need to perform this step if you use database-specific backup /

          restore methods for export and import.

       

      can you please give me the steps,