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
 SQL Server Administration (2000)
 Replication and Database Restore

Author  Topic 

snarayan
Starting Member

10 Posts

Posted - 2005-03-21 : 17:43:22
Hi

Currently running MS SQL 2000 Server with Merge Replication between 2 SQL Servers. First Server is publisher and second server is subscriber. This is running fine. No problems.

Now on first server ( publisher) do a full backup of database ( user DB not the Master, Model or Temp). Then the backup is restored on a new machine. After restore when I look at the database using Enterprise Manager I see

1. The hand icon on the database.
2. Under Replication/Publication folder See list of publication but when I click on a publication there are no items

Question
Why is the replication information getting transfered
How do I remove the dead replication entries.

Thanks
Sanjay
   

- Advertisement -