DR on SQL2008 using log shipping method

[Former Member]

Hi All,

We are planning to build DR using Log shipping method for our system which are located at 2 different locations.

We are using SQL 2008 as our database.

Also ours is a distributed environment in which the Database and the application servers are installed on different servers.

Please do let me know if there is any guide for the same so that i can replicate all the data from my production servers(database and applicaiton server) to the Disaster revcovery servers.

Thanks & Regards,

Nitin Kedare

[former_member189546]

Hello,

Please check

www.service.sap.com/ha

regards,

John Feely

[Former Member]

Hi,

Below links may help you...

[SQL Server 2008 - Database Mirroring Overview|http://msdn.microsoft.com/en-us/library/ms189852.aspx]

[SQL Server 2008 - Designing and Implementing: Tutorials (Replication)|http://msdn.microsoft.com/en-us/library/aa337389.aspx]

and

[Database-Mirroring-in-SQL-Server-2008|http://www.databasejournal.com/features/mssql/article.php/3828341/Database-Mirroring-in-SQL-Server-2008.htm]

Regrads.

Rajesh Narkhede

[Former Member]

Hi Rajesh,

Thanks for our reply and all the links which you have provided me.

I would also like to know if there is any Note for the same.

Secondly my Application server is on different host so i would like to know, under disaster receovery how will I be able to replicate my application server data and start the other system.

Please do help me in geting answers for these two questions.

Thanks & Regards,

Nitin Kedare

[Former Member]

Note 1101017

Note 965908 - SQL Server Database Mirroring and SAP Applications

The DR configuration is for JAVA+ABAP or JAVA or only ABAP.

for ABAP only application server will not hold much data, transactional data will be stored on database level. I suggest you can sync /sapmnt/<SID>/global/ and /sapmnt/<SID>/profile/

[Former Member]

Hi Sunil,

Thank you very much for your quick reply.

My system is only ABAP. There is no JAVA thats installed.

So as per your update if i have the folders mentioned by you in sync then my disaster system will start.. right.

Also any idea on how much time it takes for making this system up during such cases.

Regards,

Nitin