Using ReFS with SQL Server

Can ReFS be used with SQL Server?

John Savill

April 19, 2013

1 Min Read
Using ReFS with SQL Server

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