Answers

Question and Answer:

  Home  SQL Administrator

⟩ Tell us how many files can a Database contain in SQL Server?How many types of data files exist 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 thetotal # of files is less than 32,767 files

 224 views

More Questions for you: