x

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 at 07:58 AM in Default

avatar image

Priyanka_CN
1

(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 at 08:23 AM

avatar image

Waqar_lionheart
101 4

(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x377
x86

asked: Jul 14 at 07:58 AM

Seen: 10 times

Last Updated: Jul 14 at 08:23 AM

Copyright 2017 Redgate Software. Privacy Policy