Full vs Transaction Log Backups

60 pts.
Tags:
SQL Backup
SQL Log Files
SQL Server
Is it nessisary to perform a log backup on a database that is set to Full recovery if I am uninterested in doing a point in time restore? I could opt for Simple, but, really my question is, why? My question also goes on to the size of the ldf file, and will it reuse space and not have to grow if I never do transaction log backups...
ASKED: October 8, 2009  3:11 PM
UPDATED: October 8, 2009  4:50 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

If your database is set to FULL recovery then yes you need to do transaction log backups. A full backup doesn’t allow the SQL Server to remove the entries from the log file. This ONLY happens when the log is backed up.

If you don’t need point in time recovery of your transaction log change the database recovery to SIMPLE.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following