Wednesday, March 7, 2012

Restore a Publication

I want to restore a full backup of one of our customers Publication
databases (SQL 2k) to our test server. When I try it, all of the
replication info is dropped, which is ok as I can just go through
re-creating the publication. Is there a better way to accomplish this as I
don't want to create a temporary subscription and get a snapshot each time I
need to get an updated copy of the database. Thanks.
David
restore with the keep_replication switch
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:eDTEG93HGHA.240@.TK2MSFTNGP11.phx.gbl...
>I want to restore a full backup of one of our customers Publication
>databases (SQL 2k) to our test server. When I try it, all of the
>replication info is dropped, which is ok as I can just go through
>re-creating the publication. Is there a better way to accomplish this as I
>don't want to create a temporary subscription and get a snapshot each time
>I need to get an updated copy of the database. Thanks.
> David
>

No comments:

Post a Comment