Problem solve Get help with specific problems with your technologies, process and projects.

Moving replicated database without dropping publication

Is there a way to move a SQL-replicated database from one server to another without dropping the publication? I have SQLCE setup with SQL Server 2000; I want to redo the server, but need to move my replication to a temp server and then back. The problem is that I do not want to drop my subscription and recreate it. It needs to stay the same.

It isn't possible. You have to drop it and recreate it. This is because the replication engine, via all of the...

metadata, is tied into the specific server endpoints in order to be able to connect and perform its work.

For More Information

This was last published in April 2004

Dig Deeper on SQL Server Replication

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.