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

Cluster Disk Resources Migration Expand / Collapse
Author
Message
Posted Saturday, April 26, 2014 7:15 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 4:00 PM
Points: 96, Visits: 252

System Specs
2 Node Cluster Active/Active each with an instance
Windows Server 2003
SQL Server 2005

Project: we are changing our SAN from an HP EVA to NetApp and we needed the drives in the cluster moved to the NetApp

Plan: The SAN Admin provisioned drives from the NetApp to both nodes on the cluster, I added the disk resources to the cluster keeping the old disk resources there (for rollback if needed), I then shut off the SQL Server Services, copied all the Database files, Log Files, Program File Folders and MS SQL Server folders from the old drives to the new drives, give the old drive new names, Drive letters and Cluster Resource names and then gave the new disk the name, drive letters and cluster resource names of the old disks. Hope that was not more work than needed. I did this because of the Program File Folders and did not want to spend hours detaching and attaching databases.

Problem: the exact same problem happened on both servers.
A: When I first tried to start SQL Server Service it failed (would not start in a timely manner), I checked the event log and found access denied messages to errorlog files. I tried several permission modifications, but the one that fixed it was to give Users Full control to the whole MS SQL Server folder.

B: I got the service started, but when I tried to access the properties of any of the database I would get an error … disk either does not have sufficient space, there is not enough memory or access is denied. I also tried several permission modifications like taking owner ship, letting folders inherited from parent, but the fix was to give the SQL Service Account full control to the DATA and LOG folders. Once done the database properties and tables could be viewed.

I don’t understand why I had to add this permission to get SQL to work. I copied all these folders from the original EVA SAN Disk drives to the new Net App SAN and all the permission were exactly the same.

Do you guys have any idea what could be the problem?

Your help is appreciated.


Jeff
Post #1565383
Posted Monday, April 28, 2014 9:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 10:20 AM
Points: 261, Visits: 469
My memories of Windows 2003 are getting a little dim (thankfully). Do you have something like UAC (User Access Control) enabled on the server? In know this can be a problem accessing some of the folders on a Windows 2008 server.
Post #1565629
Posted Monday, April 28, 2014 10:22 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 4:00 PM
Points: 96, Visits: 252
Thanks for replying.

No there is not UAC on these servers as far as I know.


Jeff
Post #1565645
Posted Tuesday, April 29, 2014 2:38 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:38 AM
Points: 2,880, Visits: 3,237
If you copy the folders without also explicitly copying the permissions, then the problems you had would be expected. The SQL Server install sets a lot of folder permissions which are needed if SQL Server is to run correctly.

Both XCOPY and ROBOCOPY have parameters which force the copying of permissions. The COPY command and copy/paste within Windows Explorer does not copy permissions.



Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1565802
Posted Tuesday, April 29, 2014 12:59 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 4:00 PM
Points: 96, Visits: 252
I understand.

Thank you very much for the help. Next time i will use XCOPY or ROBOCOPY to move the data.

Your help is much appreciated.


Jeff
Post #1566103
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse