DR system ( log shipping method for MSSQL 2005)

[former_member638632]

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

[Former Member]

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ú

[Former Member]

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

[former_member184473]

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