Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Currently we have SQL Server 2005 as a publisher and SQL 2008 R2 as subscriber for one of our database (about 350 GB in size). I want to move the replication to our different server (Which also has SQL 2008 R2 installed). What are the steps involved doing this?.

share
    
Have you tried googling? –  sam yi Dec 26 '13 at 21:52
    
Check my answer to see if it helps you or not. –  Kin Dec 28 '13 at 3:56
    
Do you want to move publisher from SQL server 2005 to SQL server 2008 ? –  Kuba Miazek Dec 28 '13 at 18:14
comments disabled on deleted / locked posts

migration rejected from stackoverflow.com Feb 20 at 14:29

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by Mark Storey-Smith, RolandoMySQLDBA, Max Vernon, Michael - sqlbot, Kin Feb 20 at 14:29

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

I Dont see any surprises involved in moving the servers which are involved in replication. Please plan for the activity considering downtime you have and snapshot agent last run time history for your database size.

share
add comment