Why we need to use secondry database file? though, we can
do same work using primary database file also.

Answers were Sorted based on User's Feedback



Why we need to use secondry database file? though, we can do same work using primary database file..

Answer / 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

Why we need to use secondry database file? though, we can do same work using primary database file..

Answer / sagi.rahul

Secondary files can be used to spread data across multiple
disks by putting each file on a different disk drive which
will improve i/o.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is resource governor?

0 Answers  


What is the sql profiler?

0 Answers  


How to create a simple table to test triggers in ms sql server?

0 Answers  


Mention the different authentication modes in sql server.

0 Answers  


What is the difference between Stored Procedures and triggers?

0 Answers   HCL,






What is index in an assignment?

0 Answers  


Can you explain what is the use of custom fields in report?

0 Answers  


You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  


What are cursors in ms sql server?

0 Answers  


what is isolation level at dead lock?

0 Answers   Verizon,


What is the query and subquery?

0 Answers  


Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  


Categories