Friday 8 January 2016

How many files can a Database contain in SQL Server?How many types of data files exists in SQL Server? How many of those files can exist for a single database?

A Database can contain a maximum of 32,767 files. There are Primarily 2 types of data files Primary data file and Secondary data file(s)
 There can be only one Primary data file and multiple secondary data files as long as the total # of files is less than 32,767 files

No comments:

Post a Comment