Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Backup and Restore
0 views
Skip to first unread message
tk...@yamner.com
May 12, 2004, 4:10:40 PM5/12/04
to
Running SQL Server 2K. I use transactional Replication.
It is sometimes necessary to take precautionary backups during
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,
Tom
Paul Ibison
May 12, 2004, 5:10:28 PM5/12/04
to
Tom,
if you mean the error from the Log Reader Agent because it detects that the
Distributor is ahead of the Publisher, you can run sp_replrestart in the
publication database with no parameters. This forces replication to continue
even if the Distributor and some Subscribers may now have data that the
Publisher no longer has. If not, please can you post up the error message.
HTH,
Paul Ibison
if you mean the error from the Log Reader Agent because it detects that the
Distributor is ahead of the Publisher, you can run sp_replrestart in the
publication database with no parameters. This forces replication to continue
even if the Distributor and some Subscribers may now have data that the
Publisher no longer has. If not, please can you post up the error message.
HTH,
Paul Ibison
Hilary Cotter
May 12, 2004, 8:35:06 PM5/12/04
to
exactly what is the error you get during the restore?
--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
<tk...@yamner.com> wrote in message
news:c14f01c4385d$32a6e950$a401...@phx.gbl...
0 new messages