How To Recover Marge Replication
-
Thursday, October 04, 2012 8:34 AM
Hi
My colleague has deleted Publisher by mistake, here were 14 subscribers which is located difference cities.
We are restore backup than publisher and subscribers show, but get subscriber properties its show error “The publication 'Pub' does not exist (ms sql 2005 error, 20026)”
And I don’t have Distribution db backup.
Do you have any solution.
All Replies
-
Thursday, October 04, 2012 11:33 AM
Salam Umar,
Can you specify if you are using a Local or Remote Distributor ?
Thanks
Said RAMADA
Microsoft Gold Certified from MS Virtual Academy
Please vote as helpful or mark as answer, if it helps Cheers Said RAMADA
-
Thursday, October 04, 2012 11:39 AM
I am using local Distributor ...
-
Thursday, October 04, 2012 12:03 PMCheck if a DataBase named Distribution still exist under :
C:\Program Files\Microsoft SQL Server\MSSQL10_50\MSSQL\DATA
Please,let me knowPlease vote as helpful or mark as answer, if it helps Cheers Said RAMADA
-
Thursday, October 04, 2012 12:34 PM
yes it is exist.
-
Thursday, October 04, 2012 1:24 PMModerator
Try to restore the publication and distribution databases with the keep replication switch.
If the distribution database is gone you will need to recreate it and then recreate the publications and subscriptions.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Thursday, October 04, 2012 5:28 PM
Hi Umar,
The distribution database stores replication status data, metadata about the publication, and, in some cases, acts as a queue for data moving from the Publisher to the Subscribers.
Now, you need to recreate a new Distributor using the Distribution Database instead of creating new one.
Cheers
Please vote as helpful or mark as answer, if it helps Cheers Said RAMADA
-
Thursday, October 04, 2012 5:32 PMModeratorThere is no indication that there is a problem with the distribution database. The publications appear to have disappeared. Restoring the publication database with the keep_replication switch will bring back all publications and it should work with the existing distribution database.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Friday, October 05, 2012 5:56 AMwe have only our Customize DB Backup , don't have distribution and publication backup.
-
Friday, October 05, 2012 2:23 PMModeratorSounds like you are in a bad way then. I am not sure at this point what to suggest.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Friday, October 05, 2012 5:27 PMModerator You will need to reconfigure replication. Do a manual a manual Merge of data using tablediff utility or SQL Data Compare if necessary. Then set everything back up again.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Sunday, October 14, 2012 2:02 PM
.png)
