BW QA System Refresh

[Former Member]

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

[cherry_tian]

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.

[luisdarui]

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

[Nicolas]

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