Monday, March 26, 2012

Log Shipping Resync process

Does anyone know how to reset or resync the Log Shipping Transaction on
the Standby Server?
I am in testing mode and ran a backup log dbname with truncate_only and
it caused my log shipping mechanism to fail and now I need to know how
to resync the process without having to Re-implement the maintenance
plan.
P.S. Is there a better method of shrinking my database logs using Log
Shipping?
Thanks,
BillTry this.
1) Disable all the logshipping jobs so they don't run
while you work. These are "Logshipping copy %"
and "Logshipping restore %" on the secondary; and "DB
Backup" and "Transaction log backup" on the primary.
2) Manually run the "DB Backup" job on the primary.
3) Copy that backup file to the secondary and restore the
file using the norecovery and standby options in the
restore database command. The standby option is if your
secondary was in readonly mode.
4) The databases should now be in sync. Run the
trasaction log backup on the primary. Then run the
Logshipping copy job on the secondary. Then run the
Logshipping restore job on the secondary. They should all
run successfully.
5) remember to reenable all your logshipping jobs.
This was a very quick summary. Hope it helps.
>--Original Message--
>Does anyone know how to reset or resync the Log Shipping
Transaction on
>the Standby Server?
>
>I am in testing mode and ran a backup log dbname with
truncate_only and
>it caused my log shipping mechanism to fail and now I
need to know how
>to resync the process without having to Re-implement the
maintenance
>plan.
>P.S. Is there a better method of shrinking my database
logs using Log
>Shipping?
>Thanks,
>Bill
>.
>

No comments:

Post a Comment