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

Alan 46 Reputation points
2022-11-19T22:29:28.083+00:00

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

SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Dan Guzman 9,406 Reputation points
    2022-11-19T22:39:53.587+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.