Running SQL Server 2K. I use transactional Replication.
It is sometimes necessary to take precautionary backups
during business hours for various reasons. However, I have
noted that backups made while replication is running can
not be made without causing an error during Restore. Is
there a workaround for this, or does Replication need to be
diabled prior to backup?
Thanks,
TomWhat error do you see during restore? To keep replication during a restore
you have to use TSQL and specify the KEEP_Replication option. However,
without this option it should restore fine, it will just strip out the
replication. The option is not available in Enterprise Manager.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment