Install MS SQL 19 Instance on NFS

Meyers, Martel 41 Reputation points
2020-12-07T20:45:52.933+00:00

During "Feature Selection" stage in SQL Server 2019 Setup, I select Database Engine Services and for Instance root directory, I specify "A:\". This drive I have tried mounting 2 different ways:

mount -o anon nolock 192.168.15.22:/export/share A:
New-PSDrive -Name "A" -Root "\192.168.15.22\export\share" -Scope Global -Persist -PSProvider FileSystem

And as seen in attached screenshot, I get the error:
"The path A:\ is not on a specified drive Type."

How can I:
a.) Install SQL 19 instance on NFS mapped drive, or
b.) Migrate an existing instance to NFS

Root issue is that there is not enough space locally to support the growth of these databases, and we need to incorporate shared storage somehow.

Thank you for your time: I have scoured the internet for days and have not found anything pertaining to this particular issue "not on a specified drive Type".

45893-notspecdrivetype.png

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,447 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,655 questions
0 comments No comments
{count} votes

Accepted answer
  1. David Browne - msft 3,766 Reputation points
    2020-12-07T21:39:58.753+00:00

    SQL Server does not support databases stored on NFS.

    It does support using SMB Shares, but not using a share mounted to a folder with NET USE, as that is session-specific.

    While specifying the SMB file share, the following are supported Universal Naming Convention (UNC) Path formats for standalone and FCI databases:

    \ServerName\ShareName\

    \ServerName\ShareName

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful