Forum Discussion

Tim_Dile's avatar
Tim_Dile
Level 5
20 years ago

SQL DB Transaction Log Question

I’ve set-up a Weekly Full
I’ve set-up a Daily Diff

Batch files were all set-up via the GUI.

What about a backup off the transaction logs? Do I also need to back these up? What’s your setup?

Thanks.
Tim
7.1.x and Earlier
Backup and Recovery
NetBackup

1 Reply

Sort By
  • Martin_Falk's avatar
    Martin_Falk
    Level 3
    20 years ago
    it depends on your needs if you backup the logs or not. If you want to perform point-in-time recovery you should backup the logs.

    I use this script for TL Backups:


    OPERATION BACKUP
    DATABASE $ALL
    EXCLUDE "Northwind"
    EXCLUDE "pubs"
    EXCLUDE "master"
    EXCLUDE "msdb"
    EXCLUDE "tempdb"
    SQLHOST "SQL-SERVER-NAME"
    MAXTRANSFERSIZE 0
    BLOCKSIZE 0
    OBJECTTYPE TRXLOG
    ENDOPER TRUE