Skip to main content
NetApp Knowledge Base

Sector size does not match the originally formatted SQL database

  1. Last updated
  2. Save as PDF
Views:
222
Visibility:
Public
Votes:
0
Category:
clustered-data-ontap-8
Specialty:
nas
Last Updated:

Applies to

ONTAP 9

Issue

  • After migrating from ONTAP 7-Mode to ONTAP 9, Microsoft SQL Server reports error when attempting to start it:

Cannot use file '\filer\DB.ldf' because it was originally formatted with sector size 512 and is now on a volume with sector size 4096. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.

  • Sector size of 4096 can be seen as Size of File System Sector Reported to SMB Clients in output from command ::> vserver cifs options show.

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.
Scan to view the article on your device