sql server - What is an MDF file? -


Is it like an "embedded" database type? Is there a file created in a database?

SQL Server databases use two files - an MDF file, known as primary See the database file, which includes schema and data, and an LDF file, which contains the logs. A database can also use a secondary database file, which usually uses the .ndf extension.

As John S. indicates, these file extensions are purely conferences - you can use whatever you want, although I do not think there is a good reason to do this.

More information about the introduction of MSDN and SQL Server 2005 Administration (Google Books).


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -