troubleshooting Question

Multiple transaction Log file or one log file?

Avatar of ali_alannah
ali_alannah asked on
Microsoft SQL Server 2008
3 Comments3 Solutions342 ViewsLast Modified:
Hello
I'm planning move/create an OLTP database that the database is 10 GB and expect to be increased 2 GB every year
My question is related to transaction Log file
which better to create  ONE transaction log file Or multiple Log>  because i read some people said ONE is better for Log .... by the way i have no problem with storage/disk spaces so i can dedicate 100 GB for transaction log on one disk

the other question is what the best RAID level for Transaction log for my database?


Note: Im using SQL server 2012
ASKER CERTIFIED SOLUTION
Psihawk99

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros