5

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.

  • 1
    What do you mean by "to the cluster" - do you already have MSCS deployed? – Jack Douglas May 29 '11 at 13:40
8

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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