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
- 6865 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
Why use sub query in sql server and list out types of sub queries?
Do you know the isolation level that sql server support?
What the different components in replication and what is their use?
What is an execution plan? When would you use it?
what is an extended stored procedure? : Sql server database administration
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is difference between Datepart() and Datename() in SqlServer?
Why do you need a sql server?
What are the commands used in DCL?
How to generate create procedure script on an existing stored procedure?
How can you start sql server in different modes?
Explain about merge replications?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Differentiate between truncate vs delete in mssql?
What is difference between drop truncate and delete?
