Reason: 0x00000003
      Message: 0 == (m_PhysicalSectorSize % m_LogicalSectorSize)
   Stacktrace: 0000558d9d8c90c1 0000558d9d91ff08 0000558d9d8cd02c
               0000558d9d8d0965 0000558d9d8cdc3b 0000558d9d8cd4d2
               0000558d9d8ce20f 0000558d9d8c2c17 0000558d9d8c1e66
      Process: 300 - sqlservr
       Thread: 471 (application thread 0x1158)
  Instance Id: af6ea342-baec-44de-a791-9c7c9537116a
     Crash Id: 94efb159-ed5c-4247-b180-a5b3a4cceb29
  Build stamp: d250a9f0724e59ff452e464a4ab43d5d070a14aef28f4ce3a48a2d785986baa6

Wanted to make use of ZFS over your run-of-the-mill disk to get all the benefits it offers. However it's a known issue that this isn't supported in such that you can't simply place the data files on a mounted pool. So I tried to use ZFS's ZVOL option to give me a traditional partition backed by ZFS, copied the database files over (after shutting down the server), remounted the new partition in the same place as the old one, and attempted to start to get the error shown above.

I'm semi-sure it's because of mssql not supporting ZFS but I wanted to post this here if anyone has any input on what might be happening.

At the moment I'm making due with a file block device located on the pool and dealing with the inherit chicken-egg problem whenever it happens.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.