Home > IT Answers > Storage > Full vs Transaction Log Backups
Jagoodie
60 pts.
 Full vs Transaction Log Backups
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...

Software/Hardware used:
ASKED: October 8, 2009  3:11 PM
UPDATED: October 8, 2009  4:50 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  October 8, 2009  4:50 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _