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.
I would say SnapMirror is an obvious choice.
In some scenarios you can leverage DataMotion for Volumes:
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.