Re: replication server crashed

From: Darin <darin_nospam@nospamever>
Date: Tue, 28 Aug 2007 12:54:51 -0700

So the master and msdb databases weren't backed up.

To use sp_addtablecontents, will that move all data that changed from
the subscriber to the publisher, or will ALL data from the subscriber be
moved? My reason is they have 3 subscribers that have been running and
subscriber 1 data needs to be moved and then 2 be moved, etc.

This is now in crisis mode for them, so any quick information would be
greatly appreciated.

Thanks.

Darin

*** Sent via Developersdex http://www.developersdex.com ***
.

Follow-Ups:
- Re: replication server crashed
  - From: Hilary Cotter
- Re: replication server crashed
  - From: Ekrem Önsoy

References:
- Re: replication server crashed
  - From: Hilary Cotter

Prev by Date: Re: Snapshot folder
Next by Date: agent profile and commandline parameter
Previous by thread: Re: replication server crashed
Next by thread: Re: replication server crashed
Index(es):
- Date
- Thread

Relevant Pages

Re: replication server crashed
... Job and History information are kept in "msdb" database and all configuration information about replication are stored in "master" database. ... the subscriber to the publisher, or will ALL data from the subscriber be ...
(microsoft.public.sqlserver.replication)
RE: unable to connect to subscriber
... This may be the case if the server has been renamed. ... On the subscriber try: ... Use Master ... Paul Ibison ...
(microsoft.public.sqlserver.replication)
Publication takes record off subscriber
... When I synch my subscriber back to my maste. ... subscriber is now on the master but it is not also on the subscriber ...
(microsoft.public.sqlserver.replication)
Re: The process cound not enumerate changes at the subscriber - Invalid character value for cast
... both the subscriber and publisher. ... DBMS: Microsoft SQL Server ...
(microsoft.public.sqlserver.replication)
Re: Problems replicating over internet....Still....
... to your Publisher to download the snapshot and transactions. ... We can't test connectivity using ping, but you can ftp from the subscriber ... go to Client network utility. ... Server, ...
(microsoft.public.sqlserver.replication)