Log Shipping: DR Drill

What is DR Drill?

DR Drill is an activity which involves actions which are taken to overcome  data loss after disaster for example if primary server down due to some reason so we can  make secondary instance to primary instance is known as disaster drill .

 Steps for DR DRILL:

Configuring DR DRILL:

1. Checking the status of logshipping

   

select secondary_database as DBNAME

last_restored_date as [LAST RESTORE DATE]

DATEDIFF(minute

case

when

DATEDIFF(minute

, last_restored_date

, last_restored_date

,

,

, primary_server as [PRIMARY SERVER]

GETDATE()) AS LATENCY

,

,

GETDATE()) < 60

,then 'SYNCHRONIZED'

else 'UNSYNCHRONIZED'

end

as [LOGSHIPPING STATUS]

from msdb

go

sp_help_log_shipping_monitor

select secondary_database as DBNAME

case

when

DATEDIFF(minute

then 'SYNCHRONIZED'

else 'UNSYNCHRONIZED'

end

as [LOGSHIPPING STATUS]

from msdb

go

                                                                   

2. On primary server run backup job and disable

3. On secondary server run copy job and disable 

4. On secondary server run restore job and disable

Verify that job is disabled:

5.  Run backup log command on primary server with norecovery option

6. Restore with recovery on secondary server.

7. Configure log shipping on secondary server

Specify copy path:

Close wizard after configuration:

Check that backup job is created on the primary server:

Check copy and restore job are created on secondary server:

Check the sync status: