Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is a quick way of migrating 75G database to the cluster? I tried to test the backup and restore and it took more than 2 hrs. Business owners won't accept the long outage. Any idea how I can make this fast or how to accurately do it? This is on SQL server 2008 R2.

share|improve this question
What do you mean by "to the cluster" - do you already have MSCS deployed? – Jack Douglas May 29 '11 at 13:40
up vote 8 down vote accepted

One of the easiest ways to use a full backup to prepare, a differential to migrate.

First off, you do a full backup and restore to prepare the files on the new server disks, but use the RESTORE .. WITH NORECOVERY option to allow more restores.

At the time of migration, you do a differential backup/restore. This is far quicker and you use RESTORE .. WITH RECOVERY this time.

share|improve this answer
touche sir ;) .. :D – jcolebrand May 29 '11 at 8:06

Your Answer


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.