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.

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

System Details:

Production System

DB Name: B12

Schema Name:B12

QA System:

DB Name: B11

schema name:B11

Thanks in Advance

Sel

[Former Member]

Hi Sel,

either you run DB2 or other DB vendor, we recommend to use SapInst tools, please see

Regards,

Javier

[former_member182505]

Hello Sel,

You requirement seems you have MS SQL server database ,

If this is the case please open a request in SQL group,

You can do Atach detach on SQL , and it is possible in different  SID,

If you have DB2 data base , you can use backup restore with sapint,

Thanks

Sadiq