Re: about re-install replication after I restore database
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Wed, 10 Jan 2007 11:43:13 -0500
Its hard to restore a publication database on another server. On the same
server you might be able to restore it using the keep_replication switch and
have everything work fine.
After you restore the database and the publications show up you should try
to script them and then recreate the publication to have everything
consistent.
--
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
"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BA3600A1-F340-4CE5-B24B-0F34E9B0A60A@xxxxxxxxxxxxxxxx
Hi guys,
I am want to re-create publication after I restore database. because I
didn't setup replcaiton using sp_replicationdboption command, all
replication
info lost after I did restoring database. When re-create publication with
same publication name, gave me error like Could not drop publication. A
subscription exists to it. but when I run sp_addpublication_snapshot, gave
me
error Object 'Web Policy Publication' does not exist or is not a valid
object
for this operation.then I coudn't run add article, because the publication
is
not existed. How can I fix it. Thanks.
.
- Prev by Date: Re: Replication monitor
- Next by Date: Re: Question about "Distribution clean up: distribution" Job
- Previous by thread: Replication monitor
- Next by thread: Re: Question about "Distribution clean up: distribution" Job
- Index(es):
Relevant Pages
|
