Monday, March 12, 2012

Move replicated DB to different server?

Is it possible to move/migrate a replicated database to a different server without breaking the subscriptions etc?

If so, is there a guide on how to do this?

Many thanks for your help in advance!

best regards, Stefan

I think first move master, model and msdb to new server...

then move publisher database to new server...

script agents and check properties in msdb and master, execute it in a new server

similar to logins also....

I have concerns about SQL Server 2000/2005 will take any OS Parameters by default? db id and other uid's concerned with database must be ideological to its env..

if you have any other idea, please publish. it helps for DR Procedures...

Thanks,

|||When you restore all the system databases and the replicated database all the agent jobs are there but they all fail because of user/owner/security problems....

So you mean to remove all those jobs and re-insert them by scripts?
|||

The user is service account (SQL Server job agent, SQL Server service account) must from the instance domain account where it copied.

Did you try with change in job owner back to new domain?

No comments:

Post a Comment