"Darin" <darin_nospam@nospamever> wrote in message
news:eYDxzAQ6HHA.4476@TK2MSFTNGP06.phx.gbl...
> 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 ***

"Darin" <darin_nospam@nospamever> wrote in message
news:OHazM1a6HHA.2208@TK2MSFTNGP06.phx.gbl...
> 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 ***

"Ekrem Önsoy" <ekrem@btegitim.com> wrote in message
news:DDBE2D8A-1C43-4A71-8AF9-7F4165193514@microsoft.com...
> Hello Darin,
>
>
> As far as I know, Job and History information are kept in "msdb" database
> and all configuration information about replication are stored in "master"
> database. So as you can not restore them (because you said you don't have
> their backups) it means you lost your replication configuration in the
> publisher and as Master Hilary commented in his last message, I think
> you'll have to reconfigure replicatication in the publisher over again.
>
> But you better wait for the verdict of the master :)
>
> --
> Ekrem Önsoy
>
>
>
> "Darin" <darin_nospam@nospamever> wrote in message
> news:OHazM1a6HHA.2208@TK2MSFTNGP06.phx.gbl...
>> 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 ***
>

"Darin" <darin_nospam@nospamever> wrote in message
news:OHazM1a6HHA.2208@TK2MSFTNGP06.phx.gbl...
> 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 ***