0

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?

Joe Doyle
  • 1,681
  • 14
  • 15
user34402
  • 261
  • 1
  • 5
  • 10
  • You could do with re-tagging this question. 'mssql-maintenance' isn't a well established tag; there are several other more appropriate tags (sqlserver, for example) and you might want to add on 'replication' for future reference as well - I'm afraid I don't have sufficient rep on here yet) – CJM Feb 10 '10 at 14:17
  • Is this a one-off requirement or an ongoing one, you don't say? if the former then just a backup and restore will be fine. – Chopper3 Jul 01 '10 at 13:04

2 Answers2

0

You might want to look at database mirroring to replicate the data...there's a white paper here.

Bart Silverstrim
  • 31,092
  • 9
  • 65
  • 87
0

Replication seems like the most obvious answer; specifically Transactional Replication.

CJM
  • 730
  • 2
  • 12
  • 28
  • Not really, requires a significant amount of possibly database changes. – TomTom May 05 '10 at 04:58
  • Is that one time? In this case I would go with mirroring. Contrary to Replication that works without changing the db structure. Once the mirror is complete, switch over sql servers and be done with it ;) Log file shipping is another method. – TomTom May 05 '10 at 04:59