Homogeneous system copy with SQL Server 2008 / NW7.0

[Former Member]

Hi,

I want to make a Homogeneous system copy from Prodcution.

Would you please let me know what are the steps and notes I have to follow.

I have a QAC system installed , I want to make a system copy from PRD and overwrite QAC with PRD database. will restore of the PRD database as QAC will work or I have to follow the sapinst steps for system copy?

Thanks,

Al

[former_member184473]

Hello Al,

You can follow note 151603 for the necessary information.

Regards,

Eduardo Rezende

[Former Member]

Hi dude!

Let me add some info to Eduardo Rezende's reply: it's better if you DON'T detach any database, because if something goes wrong (imagine that you had a corruption) you won't be able to attach that database anymore... then you can simply stop the SQL Server services and duplicate the relevant files (.mdf, .ndf and .ldf). These files can be attached to another SQL Server (same release or upper) as it they were a detached DB.

On the other hand, I recommend you checking also note 1152240, specially section IV ( System Copy on SQL Server 2008 ). And refer, obviously, to the general guides for system copy, that you will find on the System Copy section in the Marketplace, and follow the specific guide for your particular release.

Cheers!!

-Jesú