Tuesday, March 20, 2012

Replication and Log shipping work together

I want to setup replication and log shipping at
production environment, I have several questions:
1.What's the sequence of setup? replication first or log
shipping first or doesn't matter?
2.Does they work fine together?
Thanks
David Liu
moneris.com
MCSE MCDBA
1) replication first
2) log ship second.
Actually this is a complex question.
Here's what you need to do
1) backup your publication database, your distribution database, and your
msdb database
2) restore them on the standby server. Restore them with the
Keep_replication switch.
3) set the sync_with_backup option on your publication database, and
possibly your distribution database.
4) ship the logs.
5) when the publisher goes south, rename the standy server with the name of
the original publisher and reboot
6) user sp_replrestart and the skiperrors switch on the publisher until
everything works again.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"David Liu" <david.z.liu@.moneris.com> wrote in message
news:5b8101c4813a$3f339d50$a601280a@.phx.gbl...
> I want to setup replication and log shipping at
> production environment, I have several questions:
> 1.What's the sequence of setup? replication first or log
> shipping first or doesn't matter?
> 2.Does they work fine together?
> Thanks
> David Liu
> moneris.com
> MCSE MCDBA

No comments:

Post a Comment