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.

Improve this question
1
  • 1
    What do you mean by "to the cluster" - do you already have MSCS deployed?
    – Jack Douglas
    Commented May 29, 2011 at 13:40

1 Answer 1

Reset to default
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.

Improve this answer
1
  • touche sir ;) .. :D
    – jcolebrand ♦
    Commented May 29, 2011 at 8:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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