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 while using
Log
Shipping?

Thanks,
Bill

Bill,

With log shipping in place, just back up your primary database and restore
it to the secondary without recovery, choosing the read-only or norecovery
setting.

Ron
--
Ron Talmage
SQL Server MVP

"William Enloe" <william.enloe (AT) domail (DOT) maricopa.edu> wrote