Showing posts with label temporarily. Show all posts
Showing posts with label temporarily. Show all posts

Tuesday, March 20, 2012

Re_init for Log Shipping?

Does anyone know if the Log Shipping can be re-initialized just like Database
Replication OR can I just disable the Log Shipping temporarily then Re-enable
it later OR I have to start over the whole setup process again?
Thanks
Ed
You can re-initialize it via a sending a new backup and then applying the
new logs, or restoring an old backup and then applying all the logs (if you
have retained them).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:640B6823-AAB2-4ACF-9798-A701FC4B4C39@.microsoft.com...
> Does anyone know if the Log Shipping can be re-initialized just like
> Database
> Replication OR can I just disable the Log Shipping temporarily then
> Re-enable
> it later OR I have to start over the whole setup process again?
> Thanks
> Ed
>
|||I think another way is to generate T-SQL scripts so that running the whole
script can re-init. the log shipping.
"Hilary Cotter" wrote:

> You can re-initialize it via a sending a new backup and then applying the
> new logs, or restoring an old backup and then applying all the logs (if you
> have retained them).
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Ed" <Ed@.discussions.microsoft.com> wrote in message
> news:640B6823-AAB2-4ACF-9798-A701FC4B4C39@.microsoft.com...
>
>