Groups | Blog | Home
all groups > sql server replication > july 2007 >

sql server replication : Restoring Backup of Replicated Database



Maer
7/12/2007 4:52:04 PM
Hi Everyone,

A backup of a replicated database (merge publication) was created and I
need to restore that in a different server so that I can take a look at the
conflict tables when that backup was created.

Basically I am interested in restoring the conflicts tables. However,
because I am restoring this backup in a different server, it wipes out all
meta data pertaining to replication including the conflict tables.

How to I get to the conflict tables in this backup? What are my
alternatives?

If I restore the database in the same server but with a different name
(I don't want to restore the same database) will the conflict tables be
deleted there too?

Thanks,
Maer

Hilary Cotter
7/12/2007 10:52:44 PM
use the keep_replication switch while restoring.

--
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
[quoted text, click to view]

AddThis Social Bookmark Button