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.
Tell me more
×
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. It's 100% free, no registration required.
|
|
|||||
|
|
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 At the time of migration, you do a differential backup/restore. This is far quicker and you use |
|||
|
|
