Sunday, February 12, 2012

Backing up Transaction Log

Hellow World!
In what circumstances do we need backing up transaction log? We have a
transaction log backup in the middle of the night, when no transaction is
taken place because of the nature of the business. I have a feeling that we
don't need to backup the trans log at that time, but in the middle of the da
y
where we have lots of transaction for our OLTP databases.
But I just want to confirm with you all. Please provide references if
possible.
Thanks.How often you want to perform transaction log backup is dictated by the amou
nt of data loss that you
can accept. I tend to go from every 10 minutes to every hour, depending on t
he business
requirements. In some cases, I do it less frequent, or only database backup,
but those are rather
rare (like database is re-populated each night or week from external sources
).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"C TO" <CTO@.discussions.microsoft.com> wrote in message
news:BE64C12D-BF07-4EA4-B0F6-8EE6FCC7CCD0@.microsoft.com...
> Hellow World!
> In what circumstances do we need backing up transaction log? We have a
> transaction log backup in the middle of the night, when no transaction is
> taken place because of the nature of the business. I have a feeling that w
e
> don't need to backup the trans log at that time, but in the middle of the
day
> where we have lots of transaction for our OLTP databases.
> But I just want to confirm with you all. Please provide references if
> possible.
> Thanks.|||Kind of depends if you ever want to be able to restore back to a specific
point in time or not or if to the last day's FULL Database backup is
sufficient. Also, if you want to use a tool like Lumigent's Log Explorer to
UNDO specific transactions, then you'd need to frequent, during business
hours, transaction log backups.
I can not see why in an OLTP environment this would even be questioned. Is
your data not that important to your organization?
Sincerely,
Anthony Thomas
"C TO" <CTO@.discussions.microsoft.com> wrote in message
news:BE64C12D-BF07-4EA4-B0F6-8EE6FCC7CCD0@.microsoft.com...
Hellow World!
In what circumstances do we need backing up transaction log? We have a
transaction log backup in the middle of the night, when no transaction is
taken place because of the nature of the business. I have a feeling that we
don't need to backup the trans log at that time, but in the middle of the
day
where we have lots of transaction for our OLTP databases.
But I just want to confirm with you all. Please provide references if
possible.
Thanks.

No comments:

Post a Comment