Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving LUN's from existing server to new cluster Expand / Collapse
Author
Message
Posted Thursday, July 12, 2012 1:04 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 8:13 PM
Points: 124, Visits: 750
Hi,

We are planning to move from standalone server to cluster environment. As our databases are of huge size, we are planning to move the LUN's from existing server to new cluster group for min. downtime. What precautions we need to follow in order to successfully finish this process ?

Thanks,

Post #1329125
Posted Thursday, July 12, 2012 1:46 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:26 PM
Points: 316, Visits: 1,497
detach the database files before moving the luns.
Post #1329147
Posted Thursday, July 12, 2012 1:47 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 2,899, Visits: 3,112
I would take a backup of all the databases prior to the move in case something was to happen to the luns during the move.

I would also run select name, physical_name from sys.master_files and save it before detaching the databases because the drives/mount points might not come up the same on a different server and you will likely have to re-letter the drives.

Here is the process I follow:

1. Script out detach and attach statements
2. Run select name, physical_name from sys.master_files and save it for later
3. Run the detach script
4. Stop SQL server
5. Have the SAN admin offline the luns on the old machine
6. Have the SAN admin rezone the luns to the new machine
7. Have the SAN admin online the luns on the new machine
8. Re-letter the luns on the new machine
9. Run the attach script on the new machine
Post #1329148
Posted Thursday, July 12, 2012 3:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 8:13 PM
Points: 124, Visits: 750
Thanks a lot!!!!

Post #1329182
Posted Monday, July 23, 2012 6:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 23, 2012 6:29 AM
Points: 359, Visits: 109
And depending on the SAN and the SAN administrator, I would create some test LUN's and practice the move first. I've seen windows/SAN administrators get confused, and move a LUN and end up formatting it or otherwise fail to have it arrive with data intact.

It is VERY easy to move on most SAN's, do not misunderstand. But if they haven't done this before, have the windows/SAN guys practice first. Indeed, put a database there and you can practice also.

PS. Don't forget to move the log files also. Even if empty, it is simplier to attach them in place rather than trying to recreate them.



Post #1333748
Posted Monday, July 23, 2012 7:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 6,488, Visits: 13,962
Most SAN\NAS technologies will allow you to mask off LUNs from one host and attach to another. However, it may be better to mirror the current LUNs to new LUNs and then break once synchronised and create a copy of the data that way. Your storage admin should be able to offer you more help here.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1333766
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse