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
2. On primary server run backup job and disable
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
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:
