SQL Server Database Files

Any Database Consists of two files:

Primary Files. (Extension is .mdf)
Secondary Files. (Extension is .ndf)

  • Log Files (Extension is .ldf) – It doesn’t come under file group.
  • Every Database can have only one Primary File and many Secondary Files.
  • Primary file is a starting point of Database to other files in the database.
  • There is only one Primary File for a Database.
  • By defalit files are created in Primary file.
  • Maximum of 32,766 files can be created in Secondary files.
  • Maximum of 256 file groups can be created in Database.
  • There is no file group concept for Log files.
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

  • Recent Posts

    • 450,717 hits
  • Join 37 other followers

  • Archives

  • Categories

  • March 2011
    M T W T F S S
        Apr »
  • Advertisements
%d bloggers like this: