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.