Transaction Log in a Simple Recovery Mode

Question

question

liton asked Jan 15, '14

Transaction Log in a Simple Recovery Mode

Does it matter where I put my Transaction Log if I am in Simple Recovery Mode? I put the Data and Transaction file on the same disk (RAID 5) and TempDB in RAID 10. Will I get any performance increase if I move the Trans Log to a separate drive?

transaction-log

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Jan 19, 2014 at 10:27 AM

This site works from voting. Please vote up any helpful answers by clicking on the thumbs up. Mark the final answer by clicking on the check mark.

0 ·

Answer 1 · 2014-01-15T20:08:50Z

Grant Fritchey answered Jan 15, '14

Does it matter where you store your backup? Yes. It doesn't matter if you're in simple recovery or not. The basics of the transaction log and it's behavior are the same.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2014-01-16T08:59:29Z

Wilfred van Dijk answered Jan 16, '14

The question is a little confusing and indicates a common misconception about logfiles. The usage of a transactionlog is not different if you compare it against SIMPLE or FULL recovery mode. The only difference is that in SIMPLE mode, the space being used in the logfile is marked as "can be overwritten". Generally, you should put your data- and logfiles on seperate disk (in order to prevent IO issues). I recommend this free PDF from red gate: http://www.red-gate.com/community/books/sql-server-transaction-log-management

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Jan 16, 2014 at 11:22 AM

+1 for mentioning Red Gate and Tony & Gail's book. Probably should be +2.

0 ·

question