Using ReFS with SQL Server
Can ReFS be used with SQL Server?
John Savill
April 19, 2013
1 Min Read
Q: Can I use ReFS for my SQL Server database storage?
A. There are some features of NTFS that aren't supported by ReFS, specifically named streams, object IDs, short names, compression, file-level encryption (EFS), user data transactions, sparse, hard-links, extended attributes, and quotas. SQL Server databases uses named streams and sparse files in several functions, for example DBCC CHECKDB. This means you should not use ReFS with SQL Server. Stick with NTFS.
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like