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

Question

Hi,

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

Answer 1

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.