Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Merge replication - Publisher restore

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-04-30 : 14:00:23
Rishikesh writes "April 24,2004

Dear Friend,

We have a setup a Merge replication between 1 Publisher and 12 subscriber. This is run over a company WAN. I was working fine till few days before we tried some utility, a VB frontend to carry out replication.

1. Unfortunately the utility has created Initial snapshot.
2. The size of the snapshot is more than 1 GB and hence we can not transfer over a 64 K line. This will take us days.
3. Replication is done once daily in the night.
4. The entire replication has stopped.
5. Only option is to send it over DAT tapes and attach at subscriber.
6. Is there a way out ? We want to rollback the publisher but do not have any backup of master & msdb.
7. The backup of Publication database is available.

Do let us know your view & possibly a solution. We will be very greatful.

Regards,

Rishikesh Somshetti"
   

- Advertisement -