SQL Administrator Question:
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?
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
☛ 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
| Previous Question | Next Question |
| Tell us what the different components of Replication and what is their use? | Tell us about your SQL Server DBA Experience? |