Showing posts with label restorei. Show all posts
Showing posts with label restorei. Show all posts

Wednesday, March 21, 2012

Restoring publisher and subscriber databases on other computers

Is is possible to move a complete replication-scenario to other
computers using backup and restore?
I realized, that a normal restore of a subsciber database loses all the
replication-tables.
Is there a way do perform this action without losing the current
MSMerge_Content data?
I need this for example to test replication problems of customers in a
devoloping
environment.
Andreas,
this is only practical if the computers all have the same names as the
starting computers. If this is the case, you can follow the BOL instructions
for backup and restore of replicated databases.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Tuesday, March 20, 2012

Restoring Merge Repolication... HELP!

Hi,
I accidentaly remove a publication, I need to restore it!!!
What Date Base I must restore?
I Restore de Distribution database and only restore de Agents but not de
publication.
restore the publication database into another database with the
keep_replication switch. Then script it out and run it in the original
database.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nicols Donoso" <Nicols Donoso @.discussions.microsoft.com> wrote in message
news:31ADDAF0-6E01-443A-891D-D33AB4EC1A67@.microsoft.com...
> Hi,
> I accidentaly remove a publication, I need to restore it!!!
> What Date Base I must restore?
> I Restore de Distribution database and only restore de Agents but not de
> publication.
>
>