Skip to Content
avatar image
Former Member

BW QA System Refresh

Dear All

I would like to refresh my BW QA System with the latest BW PRD System.

Basically I want the same data of the production to be in QA system.

My challenging is to do copy and attach method from PRD to QA (copying the DB files: *.ndf and *.ldf).

But my QA is configured with different DB Name and different schema name.

SAP SID is also different.

Can somebody guide me with step by step procedure to do the copy and attach method  from BW PRDto BW QA.

System Details:

Production System

DB Name: B12

Schema Name:B12


QA System:

DB Name: B11

schema name:B11



Thanks in Advance

Sel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 22, 2015 at 11:17 AM

    Hello,

    First of all, I encourage you to read the system copy guides (ABAP + Java) available at http://service.sap.com/instguides. Second, I recommend to read and follow carefully the note 886102 - System Landscape Copy for SAP NetWeaver BW

    Best regards,

    Nicolas

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 04:48 PM

    Hi Sel,

    You can use either Database Backup/Restore or Detach/Attach methods.

    SAP Note 151603 Copying an SQL Server database explains this part. The part of renaming the database, well, during the restore process you can name your database.

    If you want to change the schema of your database, you can use the SCHEMA4SAP. The following SAP Knowledge Base Article explains how to do this and where you can obtain the script:

    2086186 - How to use script SCHEMA4SAP.VBS

    You might also want to read the system copy guide, which you can access in the following address:

    http://service.sap.com/sltoolset

    Go to "Software Logistics Toolset 1.0". Scroll down the page, expand "System Provisioning" and select the System Copy guide based in your SAP NetWeaver release.

    The following discussion is also about the part of the database restore, file names, etc, you might want to read it:

    http://scn.sap.com/thread/3810601

    Regards,

    Luis

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2015 at 02:29 AM

    Hi, Sel E

    After you detach BW PRD database and log files, you could easily copy them and rename them to the QAS system environment by the following command:

          copy d:\PRDDATA1\PRDDATA1.mdf g:\QASDATA1\QASDATA1.mdf

    Please refer to SAP NOTE 151603 for the detailed procedure about database copy.

    Because the system is a BW system, there are some BW-specific actions required in the copy steps. If you only copy BW system and source system is not copied. Please refer to the attached PDF document in note 1333302 -Special procedure for BW system copy. For other scenario like copy both BW and source system, please refer to note 886102,

    Best regards.

    Cherry.

    Add comment
    10|10000 characters needed characters exceeded