Why we need to use secondry database file? though, we can
do same work using primary database file also.
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 horizontal and vertical scaling?
What is the fillfactor concept in indexes?
What is page-level compression?
How to create a view with data from multiple tables?
Do you know exporting and importing utility?
Can we deploy SSRS reports on our personal website?
What is merge join?
What is bit data type? What's the information that can be stored inside a bit column?
What are the restraints imposed on the table design by a merge replication?
How do users use Report Builder with SQL Server data sources?
List out the differences between the clustered index and non-clustered index in sql server?
Explain the steps to create and execute a user-defined function in the sql server?
What is SQL Azure Firewall?
what is datawarehouse?
What is the purpose of linked server configuration in sql server?