Help me out this...! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help me out this...!

Author

Topic

MageshkumarM
Yak Posting Veteran

61 Posts

Posted - 2011-01-03 : 02:00:30

Hi,

pls anyone help me this,

what does stands for .ndf file?

ex:-
.mdf stands for master database file..[8D]

&

.ndf is wat??????????

Regards,
MAG

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-03 : 02:32:01

Those are just the default file extensions for secondary and primary data files for a SQL database.

--
Gail Shaw
SQL Server MVP

Sachin.Nand

2937 Posts

Posted - 2011-01-03 : 03:16:25

You mean you want to know the full forms of "ndf" and "mdf ?

PBUH

MageshkumarM
Yak Posting Veteran

61 Posts

Posted - 2011-01-03 : 03:41:59

yes

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-03 : 03:49:29

ndf = Secondary Data File
mdf = Primary Data File

They're not necessarily a shortened version of anything.

--
Gail Shaw
SQL Server MVP

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-01-03 : 03:52:18

hi gail,
is mdf also called 'main database file'

quote:
Originally posted by GilaMonster

ndf = Secondary Data File
mdf = Primary Data File

They're not necessarily a shortened version of anything.

--
Gail Shaw
SQL Server MVP

MageshkumarM
Yak Posting Veteran

61 Posts

Posted - 2011-01-03 : 04:04:33

okay

.mdf stand for Master Database file.

then
wat abt this..

.ndf ????????

pls let me know

MAG,
SQL DB Developer.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-03 : 05:19:51

Secondary data file. I already told you.

mdf does not stand for master database file (or main database file). It means Primary data file. Please see Books Online reference: http://msdn.microsoft.com/en-us/library/ms179316.aspx

Quote from above link:

quote:
SQL Server databases have three types of files:

* Primary data files

The primary data file is the starting point of the database and points to the other files in the database. Every database has one primary data file. The recommended file name extension for primary data files is .mdf.

* Secondary data files

Secondary data files make up all the data files, other than the primary data file. Some databases may not have any secondary data files, while others have several secondary data files. The recommended file name extension for secondary data files is .ndf.

--
Gail Shaw
SQL Server MVP

MageshkumarM
Yak Posting Veteran

61 Posts

Posted - 2011-01-03 : 05:44:39

ok i got know,
thank gail,

Regards,
MAG
SQL newer

Abdul1435
Starting Member

1 Post

Posted - 2011-06-27 : 09:36:19

NDF,as a secondary databse file, stands for (Non-primary Database File"

wshawnmelton
Starting Member

17 Posts

Posted - 2011-10-05 : 22:57:35

If you consider Itzik Ben-Gan to be a credible source, then his T-SQL fundamentals book quote:
One anecdote states that when discussing the extension for
the secondary data fi les, one of the developers suggested, tongue in cheek, using .ndf for Not Master Data File, and the idea was accepted.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources