Move the file to a volume with a sector size that is the same as or smaller than the original sector size

Hi guys, I have installed a new application, it has a dependency on SQL Server Local Database express 2012. I have that software installed, but when i try and launch my application it immediate freezes and crashes. checking event viewer showed me there was an sql error, checking the sql error logs showed me this:

About the hard drive, 2x2TB raid0 latest raid drivers just installed

015-05-28 09:01:11.35 Server      Microsoft SQL Server 2012 - 11.0.5058.0 (X64) 
May 14 2014 18:34:29 
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2015-05-28 09:01:11.35 Server      (c) Microsoft Corporation.
2015-05-28 09:01:11.35 Server      All rights reserved.
2015-05-28 09:01:11.35 Server      Server process ID is 1552.
2015-05-28 09:01:11.35 Server      System Manufacturer: 'Gigabyte Technology Co., Ltd.', System Model: 'GA-970A-D3'.
2015-05-28 09:01:11.35 Server      Authentication mode is MIXED.
2015-05-28 09:01:11.35 Server      Logging SQL Server messages in file 'D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\error.log'.
2015-05-28 09:01:11.35 Server      The service account is 'Chiron\Ryan'. This is an informational message; no user action is required.
2015-05-28 09:01:11.35 Server      Command Line Startup Parameters:
-c
-S "MSSQL11E.LOCALDB"
-s "LOCALDB#48089E8B"
-d "D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\master.mdf"
-l "D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\mastlog.ldf"
-e "D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\error.log"
2015-05-28 09:01:11.48 Server      SQL Server detected 1 sockets with 3 cores per socket and 6 logical processors per socket, 6 total logical processors; using 6 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2015-05-28 09:01:11.48 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2015-05-28 09:01:11.48 Server      Detected 8124 MB of RAM. This is an informational message; no user action is required.
2015-05-28 09:01:11.48 Server      Using conventional memory in the memory manager.
2015-05-28 09:01:11.52 Server      Node configuration: node 0: CPU mask: 0x000000000000003f:0 Active CPU mask: 0x000000000000003f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2015-05-28 09:01:11.52 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2015-05-28 09:01:11.52 Server      Software Usage Metrics is disabled.
2015-05-28 09:01:11.53 spid6s      Starting up database 'master'.
2015-05-28 09:01:11.54 spid6s      Error: 5178, Severity: 16, State: 1.
2015-05-28 09:01:11.54 spid6s      Cannot use file 'D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\master.mdf' because it was originally formatted with sector size 4096 and is now on a volume with sector size 8192. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.
2015-05-28 09:01:11.54 spid6s      Error: 5178, Severity: 16, State: 1.
2015-05-28 09:01:11.54 spid6s      Cannot use file 'D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\master.mdf' because it was originally formatted with sector size 4096 and is now on a volume with sector size 8192. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.
2015-05-28 09:01:11.55 spid6s      Error: 5178, Severity: 16, State: 1.
2015-05-28 09:01:11.55 spid6s      Cannot use file 'D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\mastlog.ldf' because it was originally formatted with sector size 4096 and is now on a volume with sector size 8192. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.
2015-05-28 09:01:11.55 spid6s      Error: 5178, Severity: 16, State: 1.
2015-05-28 09:01:11.55 spid6s      Cannot use file 'D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\mastlog.ldf' because it was originally formatted with sector size 4096 and is now on a volume with sector size 8192. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.
2015-05-28 09:01:11.55 spid6s      SQL Server shutdown has been initiated

May 27th, 2015 6:37pm

Okay I have found the issue, but now Im struggling to find the solution.

so my C: drive is where SQl server is installed to, it has block size of 4k, however I have my user data on my d: drive which is 8k. so that I believe is where the issue is coming from.

So what I need to do is get the file that are here:

D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0

Onto the C: drive, I tried symlinks and it still errored. so I copied the contents of that folder to c:\sql\ then went into the registry and found an entry sql data path which pointed to the d drive location, so I changed that to c:\sql was very hopeful at this point however it still failed, and I see why, every call to sql is making a new instance in the registry, so now I have a second registry entry that points the data path back to d drive.

So I am hoping somewhere knows somewhere where there is a line I can change

D:\Users\Ryan\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0

to

c:\sql\

anyone??

Free Windows Admin Tool Kit Click here and download it now
May 28th, 2015 1:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics