Wednesday, March 7, 2012

Merge Replication Database move to new hardware

Hello,
How to move 50GB of Publication Database to new Hardware( New SQL Server)
quickly without loosing replication inforamtion.
Replication Type : Merge
OS : Windows 2003 Server
SQL Version : SQL Server 2000
Edition : Standard
Service Pack : SP4
Best Regards
Ponnu
This can't easily be done. You are best off to rename the new SQL Server
with the name of the existing SQL Server and then restore the master, msdb,
distribution, and published databases on to the new server.
If this can't be done you will have to script out the publications and
subscriptions, drop them in current production and redeploy them on the new
server editing the scripts for the new SQL Server name.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ponnu" <ponnu@.discussions.microsoft.com> wrote in message
news:A78A2B0E-AE39-4692-839A-0501E5AC0BFF@.microsoft.com...
> Hello,
> How to move 50GB of Publication Database to new Hardware( New SQL Server)
> quickly without loosing replication inforamtion.
> Replication Type : Merge
> OS : Windows 2003 Server
> SQL Version : SQL Server 2000
> Edition : Standard
> Service Pack : SP4
> Best Regards
> Ponnu
|||Thanks very much for your quick reply
I can restore master ,msdb, distribution databases.
Is there any way to attaché(sp_attach_db) published database rather than
restoring from the backup file.
I am wondering restoring the published database will take about 10
hours(55GB database size).
Please advise me the best solution.
Regards
Ponnu
"Hilary Cotter" wrote:

> This can't easily be done. You are best off to rename the new SQL Server
> with the name of the existing SQL Server and then restore the master, msdb,
> distribution, and published databases on to the new server.
> If this can't be done you will have to script out the publications and
> subscriptions, drop them in current production and redeploy them on the new
> server editing the scripts for the new SQL Server name.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "ponnu" <ponnu@.discussions.microsoft.com> wrote in message
> news:A78A2B0E-AE39-4692-839A-0501E5AC0BFF@.microsoft.com...
>
>

No comments:

Post a Comment