Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
renu
Starting Member
47 Posts |
 Posted - 2007-10-08 : 07:19:09
|
| hi all,What is the purpose of files?(primary secondary,transaction log ). what is the use of these files? |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-08 : 08:39:35
|
A brief description is that the MDF file(s) store all the data, the LDF (LOG) stores transactions. Primary, secondary etc are file groups that can contain multiple files. There is far too much to discuss here beyond that, your best bet is to start with books online for this information.
Future guru in the making. |
 |
|
|
|
|
|
filegroups