ARS and Quick Connect Database Log Truncation with simple recovery mode (91243)

What kind of implications exist if you have SQL set to simple vs. full recovery mode? What will happen to the transaction logs?

By design.

This can be a complex question, depending on your database recovery needs. I would suggest reviewing the following links to get familiar with the reason why the transaction logs grow so large:

Decreasing the size of the transaction logs (MSDN)

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/382a5c09-d27c-4d81-9c15-2ee96c697fd5/

A transaction log grows unexpectedly or becomes full

http://support.microsoft.com/kb/317375/

First you have to determine - do you need point-in-time data recovery? Then full transaction log is needed. Are you OK with having partial information saved to disk? Then the simple mode is for you. Both have it's drawbacks and advantages.

Please see:

http://msdn.microsoft.com/en-us/library/ms189275.aspx