Migrating 2008 R2 databses which are part of replication to a new server

We are in the process of migrating databases of SQL server 2008 R2 to new hardware and they are part of replication (publisher/Distributor/Subscriber) what is the best method to setup replication on new serer without creating snapshot. I have tried sync_tye= 'Replication support only ' while creating subscription but new articles do not get replicated any suggestions?

more ▼

asked Jul 14, 2017 at 07:58 AM in Default

avatar image


(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I set this up a long time ago so bit rusty. I have not done it without a snapshot either. Having said that, I think by logic, you are required to have a database with exact schema and correct replication user setup. So I would try to script your publisher and create it at subscription end and take it from there.

more ▼

answered Jul 14, 2017 at 08:23 AM

avatar image

101 2 8

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 14, 2017 at 07:58 AM

Seen: 40 times

Last Updated: Jul 14, 2017 at 08:23 AM

Copyright 2018 Redgate Software. Privacy Policy