Skip to Content
avatar image
Former Member

DR system ( log shipping method for MSSQL 2005)

Hi experts,

We are planning to implement a production with a DR system. The DR system located at remote site will be a standby machine for the production system on MSSQL 2005 win 2003.

Both the Production and DR system is NW 7.0 with ABAP and we are planning to install with same SID.

The DR system will be install using system copy. On the regular update from Production to DR, we are planning to use MSSQL Log Shipping method.

Please tell me the log shipping method for MSSQL 2005.

Thanks

Shoaib

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • May 25, 2010 at 08:00 PM

    Hello Shoaib,

    You can refer to note [1171650|https://service.sap.com/sap/support/notes/1171650] for further information about Log shipping on SQL Server 2005.

    Regards,

    Eduardo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 26, 2010 at 01:11 AM

    Hi Shoaib,

    you may want to look into database mirroring also, in DB mirroring you can setup automatic fail over also. I leave it there with DB mirroring there are some pros and cons with it.

    But as far as log shipping goes, its a good solution if you configure properly according to your infrastructure.

    Please download below step by step guide for log shipping for SAP.

    [http://www.boobboo.nildram.co.uk/Documentation/database/SQL_Server_Documents/SAPSQLLS.doc]

    Thanks

    Mush

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 26, 2010 at 03:01 PM

    Hi dude!

    You will find a comprehensive guide for log shipping in SQL Server 2005 for SAP systems in the PDF attached to SAP note 1101017 ( "Log shipping on SQL Server 2005" ).

    Cheers!!

    -JesĂș

    Add comment
    10|10000 characters needed characters exceeded