SQL - Full, Simple, Transaction Logs
Posted on 2010-11-12
I've been doing some research on SQL and have already asked some SQL related questions in this forum. The more research I do seems to lead to more questions.
Let's say your db is in full recovery mode and you take daily full backups. I understand ideally you take transaction log backups once per hour (depending on your environment). For arguments sake, what if you backup the transaction log once a day. Then, for restore purposes, could you only go back to the full backup and the last backup of your Tlog?