Restore Previous Backup on Logshipping Primary

Quick Question: If I want to restore an earlier database backup (rollback)
my log shipping primary - how do I ensure that I get my secondaries in sync?
Just re-create the maintenance plan? The database in question is very large,
and I'd like to be able to just do a point-in-time restore on the primary,
etc, without messing up my transaction log lineage.
Does anyone have any scripts handy?
TIA
J Roberts
Norfolk ITJohn
Backup Log file before restore full database
Disable Log Shipping
Restore the database and apply all log file/s with option at point of
time. Then enable Log Shipping and restore full and then log file backpus on
the secondary server
Actually I have not used maintenance paln fo doing Log Shipping , as I
always create scripts (stored proceduers etc..)
"John Roberts" <JohnRoberts@.discussions.microsoft.com> wrote in message
news:094ACA2D-1C92-47DE-B63C-7E7A4087FE7B@.microsoft.com...
> Quick Question: If I want to restore an earlier database backup
> (rollback)
> my log shipping primary - how do I ensure that I get my secondaries in
> sync?
> Just re-create the maintenance plan? The database in question is very
> large,
> and I'd like to be able to just do a point-in-time restore on the primary,
> etc, without messing up my transaction log lineage.
> Does anyone have any scripts handy?
> TIA
> J Roberts
> Norfolk IT|||That's what I thought. You'd think that MS would have considered rollbacks
in their implementation... Oh well. T-SQL it is. I think I'm going to use
SQL-DMO (vb.net) for this...
Thanks for your reply.
John
"Uri Dimant" wrote:
> John
> Backup Log file before restore full database
> Disable Log Shipping
> Restore the database and apply all log file/s with option at point of
> time. Then enable Log Shipping and restore full and then log file backpus on
> the secondary server
> Actually I have not used maintenance paln fo doing Log Shipping , as I
> always create scripts (stored proceduers etc..)
>
>
> "John Roberts" <JohnRoberts@.discussions.microsoft.com> wrote in message
> news:094ACA2D-1C92-47DE-B63C-7E7A4087FE7B@.microsoft.com...
> > Quick Question: If I want to restore an earlier database backup
> > (rollback)
> > my log shipping primary - how do I ensure that I get my secondaries in
> > sync?
> > Just re-create the maintenance plan? The database in question is very
> > large,
> > and I'd like to be able to just do a point-in-time restore on the primary,
> > etc, without messing up my transaction log lineage.
> >
> > Does anyone have any scripts handy?
> >
> > TIA
> >
> > J Roberts
> > Norfolk IT
>
>