Wednesday, March 21, 2012

Restoring replication

I have a problem that needs tip: Our main replica server need to be restored.
It has been the main server within a network using merge replications between
around 10 servers with publications and push/pull subscriptions. Now listen
the server was stolen and I need to restore (I got the all the *.mdf files on
a separate ghost-disk) the server. I need some good advice on how to restore
properly. I have also backup-files from all replica-databases plus master
database and distribution database. But I have not any backup on the
MSDB-database. Suggestions?
Best wishes
Basically you are hosed. All of your merge agent job information is gone.
You will have to drop your publications and subscriptions and rebuild from
scratch.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:787985FB-1CA8-47E3-8B00-0575443082D4@.microsoft.com...
>I have a problem that needs tip: Our main replica server need to be
>restored.
> It has been the main server within a network using merge replications
> between
> around 10 servers with publications and push/pull subscriptions. Now
> listen
> the server was stolen and I need to restore (I got the all the *.mdf files
> on
> a separate ghost-disk) the server. I need some good advice on how to
> restore
> properly. I have also backup-files from all replica-databases plus master
> database and distribution database. But I have not any backup on the
> MSDB-database. Suggestions?
> --
> Best wishes

No comments:

Post a Comment