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

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

Question Posted / sam

2 Answers
6187 Views
Microsoft, I also Faced
E-Mail Answers

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