Understanding how things work make troubleshooting failures easier!
Gaining additional knowledge by creating your own routines is never a bad thing either.
> Even if you don't ever NEED to "roll your own" logshipping
> It is absolutely one of the best experiences I've had. You really learn a
> I'm glad Keith Kratochvil and others took the time to put it somewhere on
> the web as
> The only way to get it back in synch is to initiate a backup on your main
> server and start the whole process over.
> You want to shrink your logs files on the primary box? Perhaps you could
> backup the logs WITH INIT and then ship them. This would prevent them from
> growing. You will have to use some type of mechanism to keep the old log
> files, however.
> Perhaps this will be helpful:
> > 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