DR Setup on SQL Server 2005

[Former Member]

Hi Gurus,

I am going to setup DR System as PRD system, am very new to DR setups kindly help me on this.

Here am going to follow this procedure, please correct me if am wrong.

1. I need to request a license for DR server and here no extra cost is required for this server.

2. Request a hardware same as Production system.

3. It is a New system so I am going to install new server with backup/restore method of PRD.

4. Stop SAP and Setup Log shipping from Live Server to DR Server.( Here i want to know more like what are different types of methods we have?)

Kindly answer below my doubts also:

Here how to setup log shipping from Live server to DR Server?

When disaster happen, what are the steps need to be performed to make DR Server available for business?

How much time it is required to make the system available to users?

How much estimated data loss will be there?

Thanks,

Venkat

DR Setup for Production on SQL Server 2005

[Former Member]

Hi Venkat,

Did you already read the following SAP notes?

1101017 Log shipping on SQL Server 2005

  493290 Configuring SQL server Log shipping

They already cover most of your questions. Note 1101017 is an FAQ note and has a Best Practices document attached additionally.

Regards,

Beate