Full vs Transaction Log Backups
Home > IT Answers > SQL Server > Full vs Transaction Log Backups
Jagoodie
55 pts.
0
Q:
Full vs Transaction Log Backups
SQL Server, SQL Backup, SQL Log Files
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: Oct 8 2009  3:11 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Oct 8 2009  4:50 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0