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 is federation member?
What is database dimension? : sql server analysis services, ssas
What are the different types of stored procedures?
Define the one-to-one relationship while designing tables.
Write a SQL queries on Self Join and Inner Join.
How do I open a .db file?
Can you import Microsoft Excel data to SSRS?
What is scheduled job and how to create it?
What is TDS(Tabular Data Stream) Gateway?
What is normalization of database? What are its benefits?
How to call stored procedure using http soap?
What is data compression? : sql server database administration
What is mssql?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to check table values in sql server?