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

Alan 41 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
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
    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