2012-08-24 03:46 PM
What is the best way to move a SQL database from the local server disks to an iSCSI LUN? The plan is to move the databases to my Netapp FAS2240, then snapmirror that volume to my FAS2040 for a backup. I am still somewhat new to Netapp and all of the features that are available. Any help would be greatly appreciated.
Solved! SEE THE SOLUTION
2012-08-28 03:07 AM
Use SnapManager for SQL to migrate the DB and logs from local disk to netapp lun. This would be the idle way of migration and then snapmirror from 2240 to 2040.
2012-11-30 04:31 AM
I would say SnapMirror is an obvious choice.
In some scenarios you can leverage DataMotion for Volumes:
2012-11-30 06:22 AM
Of course - Datamotion would allow the vol to move to another aggr, but this doesn't solve moving the actual DB itself.
In one situation I have a customer where a DB grew at an exponential amount.
The initial LUN was 100GB and overtime had to be resized and it currently at 1TB.
At this point, the LUN cannot be resized any larger due to the limitation of 10x LUN expansion.
So at this point, we are stuck having to move the DB to a new LUN.
I am assuming, if we performed a SnapMirror of the Vol (LUN) to a new volume, that the LUN properties would remain intact and thus be unable to grow the LUN.
At this point, I believe the only option is to physically move the DB from one LUN to a newly created LUN.
- Or use SMSQL to restore a snapshot of the DB to an alternate location on the new LUN.