Skip to Content
avatar image
Former Member

Homogeneous system copy with SQL Server 2008 / NW7.0

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • May 25, 2010 at 06:57 PM

    Hello Al,

    You can follow note 151603 for the necessary information.

    Regards,

    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded

    • 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Ăș