Realtime MS SQL Database transfer

Posted by user34402 on Server Fault See other posts from Server Fault or by user34402
Published on 2010-02-10T13:15:55Z Indexed on 2010/05/05 3:08 UTC
Read the original article Hit count: 201

Filed under:

mssql-maintenance

Hello, I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime.

Is there any way to do it?

Related posts about mssql-maintenance

Error when trying to open SQL Maintenance Plan - SSMS 2008

as seen on Server Fault - Search for 'Server Fault'
If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not load file or assembly 'msddsp, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'… >>> More
SQL restore from single file db to filegroup

as seen on Server Fault - Search for 'Server Fault'
I have a 180GB MOSS 2007 database whose maintenance (i.e. backups and restores) are becoming a problem. Part of the issue can be resolved by splitting the three content sites down into their own site collections, however this will likely still leave me with a 100gb DB to deal with. Whilst this isnt… >>> More
Realtime MS SQL Database transfer

as seen on Server Fault - Search for 'Server Fault'
Hello, I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime. Is there any way to do it? >>> More

Developer IT

Realtime MS SQL Database transfer - Developer IT

Realtime MS SQL Database transfer

mssql-maintenance

Related posts about mssql-maintenance

Error when trying to open SQL Maintenance Plan - SSMS 2008

SQL restore from single file db to filegroup

Realtime MS SQL Database transfer

Categories cloud