none
SQL server won't start. Error says database was originally formatted with sector size 4096 and is now on a volume with sector size 3072.

    Question

  • The SQL Server service won't start on my 2008 R2 system. Nothing has changed on the system, but this error is in the event log every time I try to start the service:

    Cannot use file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.VIM_SQLEXP\MSSQL\DATA\mastlog.ldf' because it was originally formatted with sector size 4096 and is now on a volume with sector size 3072. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.

    It is running on a SuperMicro server and it has 2 1TB drives setup as a raid 1 using the built-in raid adapter. There is an additional error at the same time, but it is about "master.mdf" in the same location.

    Does anyone know how to fix this?

    Monday, January 14, 2013 8:08 PM

Answers

  • Hi,

    It seems to be a SQL server related error. I found the same issue in this thread:

    http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/5c090e72-e83d-4fca-a087-75a3df5d2b4f/

    Please see if workaround provided could help. For further information you could also post a thread on SQL forum instead.


    TechNet Subscriber Support in forum |If you have any feedback on our support, please contact tnmff@microsoft.com.

    Thursday, January 17, 2013 8:17 AM
    Moderator

All replies

  • I ran "chkdsk /r /f" and then rebooted the system and it never fully came backup. I can ping the system, but I can't access any shares, rdp, or login with psexec anymore. I'll have to make a trip to the site tomorrow to get a visual on it.
    Monday, January 14, 2013 10:22 PM
  • Hi,

    It seems to be a SQL server related error. I found the same issue in this thread:

    http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/5c090e72-e83d-4fca-a087-75a3df5d2b4f/

    Please see if workaround provided could help. For further information you could also post a thread on SQL forum instead.


    TechNet Subscriber Support in forum |If you have any feedback on our support, please contact tnmff@microsoft.com.

    Thursday, January 17, 2013 8:17 AM
    Moderator