Skip to Content
0
Former Member
Nov 09, 2011 at 05:42 AM

How to Setup the DR for SQL2008

37 Views

Hi

I want to setup the DR on SQL2008 .

Following activities i have performed for the Active and stanby procedure.

1. Taken the Full backup

2. Restore it on the standy server in restoring mode

3. Configure the Transactional Log shipping for the active server.

Question :

4 . How to apply the transaction log in the standy server automatically ?

I hope this procedure is correct

Regards

haroon