March 20, 2014 at 1:06 am
Hi Experts,
We have 5 databases which will sum up to 8+TB, housed in our EDW server. We are planning to migrate to another storage system for better performance. I am planning Full backup and Differential backup and detach the DB and restore the DB in the new storage system.
Or should I detach,copy the data and log file and attach the files, will this approach have any advantages ? Please share your views. Thank you.
March 20, 2014 at 3:46 am
Both those approaches take time. Personally I would opt for backup/restore ensuring the backup is appropriately located for a fast restore. This would allow for a recovery option if something went wrong and be prepared in advance to a degree if you are willing to perform another differential backup at time of migration.
I work in a minimal downtime environment so my personal preference would be to have both storage devices presented to the instance, backup/restore one db at a time to a different db name in norecovery. Restore the db up to present using diffs/logs and recover the db. Then rename and offline the original. Finally rename the new db.
March 20, 2014 at 4:14 am
I'm also inclined towards backup and restore. It's just inherently safer than detach/attach. Further, you could set up mirroring temporarily to get the database syncronized with as little down time as possible.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2014 at 4:17 am
Grant Fritchey (3/20/2014)
Further, you could set up mirroring temporarily to get the database syncronized with as little down time as possible.
This will only work if its new storage AND a new instance. If you are simply migrating storage on the same server you cannot mirror to a different name.
March 20, 2014 at 4:40 am
MysteryJimbo (3/20/2014)
Grant Fritchey (3/20/2014)
Further, you could set up mirroring temporarily to get the database syncronized with as little down time as possible.This will only work if its new storage AND a new instance. If you are simply migrating storage on the same server you cannot mirror to a different name.
Ah, misread. I thought they were migrating the server too.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2014 at 5:15 am
Thank you Grant and MysteryJimbo for your thoughts. I am convinced and will go with backup and restore 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply