Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / sam

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 are the different types of indexes?

0 Answers   Blue Star,

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

What will be query used to get the list of triggers in a database?

0 Answers  

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

How to drop an existing table?

0 Answers  

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

what is advantages in sql 2005 over sql 2000?

4 Answers  

What is the command used to get the version of sql server?

1 Answers  

How to delete an existing row with delete statements in ms sql server?

0 Answers  

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

What is snapshot replication?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories