Interested to Buy Any Domain ? << Click Here >> for more details...
Why we need to use secondry database file? though, we can
do same work using primary database file also.
- 2 Answers
- 6748 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sivasql
The reason for secondary database files:
1. Performance
Say if we keep Read-Only and Read-Write data on the same
Primary files, fragmentation on the file will be huge. To
avoid this we can place them separate files.
2. Maintenance
If the Read-Only objects are kept on separate file, the Re-
Index sort of maintenance activities need not be performed
on this file.
3. Backup
The Read-only secondary file need not be backed on every
file level backup, it saves time
4. Microsoft Standard
Microsoft advise to keep the Primary filegroup with the
primary file to keep system related objects.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are rows and columns?
What are the Advantages of using CTE in sql server?
Is mysql the same as sql server?
What is right outer join in sql server joins?
How will you hide an attribute? : sql server analysis services, ssas
How is sql used in sql server?
How do I manually uninstall an instance of sql server 2016?
How to find tables without indexes?
How to get the definition of a stored procedure back?
What is use of dbcc commands?
How to add the custom code in Report?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Explain a differential backup?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What do you mean by table and field in sql?
