I have some Windows 2003 servers with misaligned disks. I am following the procedures from this VMware article.
http://www.vmware.com/pdf/esx3_partition_align.pdf
Basically
Add new drive to VM
diskpart select volume 2 create partition primary align=64 exit Go to Disk Management rt. click volume > format allocation size = 32k
At this point, I have the existing 😧 drive and the newly formatted volume.
This is a SQL server, so I shut down SQL services, change the drive letter of 😧 to F:.
Then give the new volume a drive letter of 😧 and remove the old drive from the VM.
I restart and I can't get SQL to start.
The error in the logs is
FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'd:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
Is this the correct procedure, or am I missing something?
Thanks,
Scott
Hello.
This procedure is correct, and this error is definitely a permissions issue. How are you copying the data over? You might want to give robocopy or xcopy a try, as they have switches that will take the ACLs with the copy. That or compare the old drive/directory with the new one, before you remove it.
Good Luck!
Hello.
This procedure is correct, and this error is definitely a permissions issue. How are you copying the data over? You might want to give robocopy or xcopy a try, as they have switches that will take the ACLs with the copy. That or compare the old drive/directory with the new one, before you remove it.
Good Luck!
That could've been it. I'll give that a shot and let you know. Thanks.
That appeared to be it. I used xcopy with the switches to copy permissions and it's working now. Thanks a lot.