How Many Files Can A Database Contain In Sql Server?how Many Types Of

1.	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?
Answer» 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 thetotal # of files is less than 32,767 files

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?

Answer»

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 thetotal # of files is less than 32,767 files