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
- 6889 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 is molap and its advantage? : sql server analysis services, ssas
How to disconnect from a sql server using mssql_close()?
How do indexes help, types?
What is filtered index?
What is sql server database?
What is create command?
Explain datetime2 data type in sal server 2008?
What is change data capture (cdc) in sql server 2008?
What is an expensive query?
Where are sql server user names and passwords stored in sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Explain transaction server explicit transaction?
Define msdb database?
How will you monitor replication latency in transactional replication? : sql server replication
What do you mean by data manipulation language?
