about re-install replication after I restore database

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.
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@.discussions.microsoft.com> wrote in message
news:BA3600A1-F340-4CE5-B24B-0F34E9B0A60A@.microsoft.com...
> 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.
>