Hello all -
We have a published db which we backup daily. In order to restore the
database, we run a scripts which removes all subscribers, restore the db,
and then run another script to add all subscribers. We then have to re-init
all. ( The remove / create scripts are generated by EM ).
Is there a more efficent way to do this? Can we take the db offline and
then do the restore & reinit?
Note that we aren't so concerned with preserving the state of the clients
and accept having to do the reinit.
Your thoughts & comments are appreciated.
Regards,
bruce
Bruce,
you could investigate the use of the KEEP_REPLICATION flag in RESTORE.
In my experience it usually it won't fully work and especially not when the
computers name is different therefore I script back the replication settings
and reinitialize.
Regards,
Paul Ibison
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment