Does SQL Server Express use MDF & NDF as the data file?

Alan 41 Reputation points


I use many version of SQL Server, including 2012, 2008, 2008R2. But have no experiences with SQL Server Express.

Does SQL Server Express also use MDF & NDF as the data file? And whether such data file can be used in SQL Server directly?

Thank you

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,800 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dan Guzman 7,306 Reputation points

    SQL Server Express Edition uses the same database engine as other editions. The storage architecture is the same, with data stored in data files along and a transaction log too. These files are maintained exclusively by the database engine.

0 additional answers

Sort by: Most helpful