asked on Multiple transaction Log file or one log file?
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
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
Microsoft SQL Server 2008
Last Comment
Scott Pletcher
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.