Is it important to backup the transaction log?

1152330 pts.
Tags:
Backup
ERP
SQL Server
Over the past few months, we've been putting in a backup solution for a client. Their ERP solution uses SQL Server but ERP was set up by a different company. They have told us multiple times that it's really important to backup everything and truncate the transaction log. Is the log that important? We're already backing up the whole system as it is. Can anyone explain this?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
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.
  • ToddN2000
    If this transaction log is functioning like an audit trail, I'd back it up as long as you have the time and storage media.
    135,305 pointsBadges:
    report
  • KeenChan

    It depends on your company retention policy and also the restore policy with the Business/Operation group.  Backing up the transaction logs with the appropriate full/Diff backup allows you to recover data to a point in time.  Here is a great 3.2.1 explanation for backup:

    http://windowsitpro.com/blog/why-3-2-1-backup-rule-still-makes-sense

     

    20 pointsBadges:
    report
  • edwinjhoffer
    Yes, It is important to backup the transaction log because the  SQL Server captures the transaction logs for many purposes.
    The SQL Server stores the transaction logs for database recovery even, we can also use the transaction logs for the database forensic purposes
    3,740 pointsBadges:
    report

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.

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

Following

Share this item with your network: