BackUp SQLSERVER Log - Veritas Backup Exec

This is a discussion on BackUp SQLSERVER Log - Veritas Backup Exec ; Since we can't backup the log file with the Truncate Log On checkpoint turned on, we have a major problem. The software will not trucate the log when it backs up the log. We could set up a Data Maintenance ...

+ Reply to Thread
Results 1 to 4 of 4

Thread: BackUp SQLSERVER Log

  1. BackUp SQLSERVER Log


    Since we can't backup the log file with the Truncate Log On checkpoint
    turned on, we have a major problem. The software will not trucate the log
    when it backs up the log. We could set up a Data Maintenance plan to do
    this periodically but should be an unnecessary step. Can some explain why
    the log can not be backed up with this switch on?

  2. Re: BackUp SQLSERVER Log

    You can run the database full backup, followed immediately by a
    TranLog/Truncate job.

    Daniel Byers wrote:

    > Since we can't backup the log file with the Truncate Log On checkpoint
    > turned on, we have a major problem. The software will not trucate the log
    > when it backs up the log. We could set up a Data Maintenance plan to do
    > this periodically but should be an unnecessary step. Can some explain why
    > the log can not be backed up with this switch on?



  3. Re: BackUp SQLSERVER Log


    How do I create a TranLog/Truncate job?


    Ken Putnam wrote:
    >You can run the database full backup, followed immediately by a
    >TranLog/Truncate job.
    >
    >Daniel Byers wrote:
    >
    >> Since we can't backup the log file with the Truncate Log On checkpoint
    >> turned on, we have a major problem. The software will not trucate the

    log
    >> when it backs up the log. We could set up a Data Maintenance plan to

    do
    >> this periodically but should be an unnecessary step. Can some explain

    why
    >> the log can not be backed up with this switch on?

    >



  4. Re: BackUp SQLSERVER Log


    On the Job definition, SQL tab, job type. It's now called just Backup Transaction
    Log as opposed to backup log no truncate

    "Edwin Gutierrez" wrote:
    >
    >How do I create a TranLog/Truncate job?
    >
    >
    >Ken Putnam wrote:
    >>You can run the database full backup, followed immediately by a
    >>TranLog/Truncate job.
    >>
    >>Daniel Byers wrote:
    >>
    >>> Since we can't backup the log file with the Truncate Log On checkpoint
    >>> turned on, we have a major problem. The software will not trucate the

    >log
    >>> when it backs up the log. We could set up a Data Maintenance plan to

    >do
    >>> this periodically but should be an unnecessary step. Can some explain

    >why
    >>> the log can not be backed up with this switch on?

    >>

    >



+ Reply to Thread