Re: replication server crashed

I am unsure what state your replication topology is in.

If the database is restored and the master, distribution, and msdb database
are still healthy, the subscribers will fill in missing transactions in the
publisher. If the entire server is restored on new hardware it must have the
same name as the old server, and the master, msdb, publication and
distribution database must be restored as well. You must use the
keep_replication switch while restoring these databases.

If any of these components cannot be restored you have to recreate your
publications and subscriptions, hopefully using scripts you have saved from
the existing topology. Once this is done use sp_addtabletocontents on the
subscriber to push the changes which occurred there to the publisher.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Darin" <darin_nospam@nospamever> wrote in message
news:eYDxzAQ6HHA.4476@xxxxxxxxxxxxxxxxxxxxxxx
One of our customers had their publisher machine crash (harddrives went
down). This is running merge replicaton. The subscribers have continued
operating today.

Their network person "backed up the database". As of right now, I don't
know exactly what was backed up and how.

Can someone point me in the right direction to get the server set back
up for merge, and have what the subscribers did today get replicated
without any issues.

Thanks.

Darin

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


.

Relevant Pages

  • Re: Replication, GUIDs and PKs
    ... This way you wouldn't be forced to use the GUID for pks. ... is bi-directional you should use merge replication and the GUIDs would be ... Director of Text Mining and Database Strategy ... are multiple subscribers, but subscribers do not subscribe to multiple ...
    (microsoft.public.sqlserver.replication)
  • Stored Procedure failed with Invalid Cursor State problem
    ... I have a database that is being merge replicated between 1 publisher and 2 ... One of the tables in this database has it's replication ... change log table that are relevant to that record to force the record to its ... One of the subscribers is frequently disconnected for a ...
    (microsoft.public.sqlserver.replication)
  • Re: How to restore / backup replicated database?
    ... " Exclusive access could not be obtained because the database is in use. ... > db) and the replication tables are removed. ... you don't remove replication prior to restoring the backup. ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge or Trans with QUS best when publishing partitions of database to slow subscribers
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The publisher will be SQL Server 2005 and all the subscribers will be SQL ...
    (microsoft.public.sqlserver.replication)
  • Re: Restore published database
    ... subscribers will backfill the missing information. ... For a transactional publication, the log reader will complain, and your best ... Looking for a SQL Server replication book? ... > I need to restore published database from backup. ...
    (microsoft.public.sqlserver.replication)