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)
Showing posts with label restorei. Show all posts
Showing posts with label restorei. Show all posts
Wednesday, March 21, 2012
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.
>
>
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.
>
>
Labels:
accidentaly,
base,
database,
date,
distribution,
itwhat,
merge,
microsoft,
mysql,
oracle,
publication,
repolication,
restore,
restorei,
restoring,
server,
sql
Subscribe to:
Posts (Atom)