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 |
|
muzzettemm
Posting Yak Master
212 Posts |
 Posted - 2008-12-19 : 16:34:20
|
| Hi guys I have a quick question, I was wondering wouldnt it be better to have a Primary File and a Secondary File for your databases?? like have the MDF in the Primary and the LDF in the Secondary file?? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-19 : 16:43:13
|
quote:
Originally posted by muzzettemm
Hi guys I have a quick question, I was wondering wouldnt it be better to have a Primary File and a Secondary File for your databases?? like have the MDF in the Primary and the LDF in the Secondary file??
You can't place log file in FG . You can spread data files across separate FG across separate disks reduce IO contension issue. |
 |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2008-12-19 : 16:45:03
|
| Oh ok By FG do you mean File Group?? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-19 : 16:53:51
|
quote:
Originally posted by muzzettemm
Oh ok By FG do you mean File Group??
Yes. |
|
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2008-12-19 : 19:10:16
|
| ok thank you very much |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-20 : 09:41:25
|
quote:
Originally posted by muzzettemm
ok thank you very much
Cool. |
|
|
|
|
|
|
files