var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Moving Databases from one server to another with replication enabled.
I have 2 databases on a remote server on which Replication and Replication Monitor is enabled. Now I want to move this databases from different remove location.
How do I transfer bboth databases with replication and replication monitor enabled on it with all the user logins.
Please help me out.
If the detached database was enabled for replication and is attached to a DIFFERENT server then 'sp_removedbreplication' should be run to remove replication from the database.
Before attempting to move a database file please ensure that you have a good backup to go back to should things go wrong.
Disable the replication move the database and enable the replication.
A link [http://www.winnetmag.com/SQLServer/A...ver_38127.html] to move the databases.
Thanks Dear Satya.. I'll try that