Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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 1 '10 at 13:04

2 Answers 2

up vote 0 down vote accepted

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

share|improve this answer
    
Not really, requires a significant amount of possibly database changes. –  TomTom May 5 '10 at 4: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 5 '10 at 4:59

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.