Stefan6791


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



Re: Move replicated DB to different server?

Jayperi


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,







Re: Move replicated DB to different server?

Stefan6791

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





Re: Move replicated DB to different server?

Jayperi

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