0

We want to install SQL Server 2019 on Windows Server 2019; currently Admin has formatted Nimble Storage with ReFS. Is it really better than NFTS? I have seen other posts wherein people have mentioned about downside of ReFS. Any suggestions \ help is appreciated.

0

So I'm not familiar with Nimble Storage or ReFS but it looks like the manufacturer (HPE) recommends against using ReFS with Nimble Storage, as a quick Google search turns up on their documentation here.

That being said, what is your Server Admin trying to achieve with Nimble Storage and/or ReFS?...this is definitely a very edge case setup as far as SQL Server goes (the majority of instances in the wild are likely running on NTFS).

In terms of reliability (which it seems like the point of ReFS is), from a database perspective, having a data redundancy, backup, and recovery plan that keeps RTO (Recovery Time Objectives) and RPO (Recovery Point Objectives) in mind is what would be recommended. Whether those objectives are accomplished through appropriately scheduled Full, Differential, and Transaction Log backups, implementing Availability Groups, or any other related means, none of them will be dependent on nor recommend a specific file system for your server's disk.

1
  • Hi JD, thank you for your reply. My Admin has configured windows 2019 server cluster with ReFS\CSVFS FileSystem. As Microsoft recommends to use ReFS link; However, my Admin is not sure if its reliable to use in Production environment – Mandar Jan 20 at 4:13

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.