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 |
|
JohnDeere
Posting Yak Master
191 Posts |
 Posted - 2004-10-25 : 08:41:06
|
| I have a clustered sql server using an EMC CX300 for storage.Are there any issues with expanding the transaction log to use multiple files and multiple drives? I need more log space and it is much easier to add an additional lun on the san and a transaction log file than to expand an existing lun and use disk part or some other utility to get windows to recognize the space. ThanksLanceLance Harra |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-25 : 11:47:49
|
| don't do it.This complicates recovery. Actually, it precludes you from certain recovery scenarios. Specifically, you can no longer use sp_attach_single_file_db if you were to somehow lose your tlog (corruption for example). btw, there is no performance benefit to using multiple logfiles.-ec |
 |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2004-10-25 : 13:19:46
|
| Thanks for the information.Lance Harra |
|
|
|
|
|
|
Multiple Transaction Log Files