I allocated too much storage to a LUN that contains one of my databases. The FlexVol that houses the LUN has also been sized too large, and I want to reclaim some of that aggregrate storage for other volumes.
I understand that I should not reduce the size of the LUN. I am planning to use SnapDrive create a new LUN within the same Volume, move the database to the new LUN, then destroy the old LUN, then reduce the size of the Volume.
I'm wondering if these are the steps I should take?:
- use SnapManager to move the database to a local drive
- delete the existing LUN (how to do this??? - never needed to kill a LUN)
- recreate a new smaller LUN using SnapDrive
- migrate the new "local" database onto the recreated LUN.
Are there any gotchas that I should watch out for, or any guidance anybody has on this procedure for a newbie?
Your steps are all fine. For deleting a LUN use SDW, it is safer and error-free that way.
I would also suggsest that you create a native SQL Server backup of the database before hand if this is a production database.
This is just incase the migration process fails. If the database is too large and your maintainance window is relatively small then uncheck the option to run "DBCC CHECKDB" before and after the migration in the SMSQL configuration wizard.
Technical Marketing Engineer (SMSQL , SMMOSS)
Contact: +91 80 4184 3482
Cell: +91 9739090394
Re: How to migrate SQL Server database from one LUN to another in same Volume?