Re: replication server crashed

All data will be "moved" but if it conflicts it will not be problematic.

--
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:OHazM1a6HHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
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 ***


.

Relevant Pages

  • Re: non-updateable merge subscription
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... exactly the result that I want (changes go to subscriber but do not come ...
    (microsoft.public.sqlserver.replication)
  • Re: Subscriber does not show up Replication monitor
    ... relevantNoise - dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... select * from MSsubscriber_info order by subscriber ...
    (microsoft.public.sqlserver.replication)
  • Re: Could not find stored procedure
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... Can you do the following on your subscriber: ...
    (microsoft.public.sqlserver.replication)
  • Re: Contains clause with only NOT keywords
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... I am designing a search screen that searches for keywords in Text ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search and Index Question
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)
Loading