1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TDP for microsoft SQL Server (log backups)

Discussion in 'TDP/Application Layer Backup' started by DavidLust, Apr 15, 2005.

  1. DavidLust

    DavidLust New Member

    Joined:
    Dec 10, 2004
    Messages:
    6
    Likes Received:
    0
    Location:
    hawaii
    Aloha,



    I can only seem to find selective and incremental backups of the sql data bases.



    is there a way to back up the log files for sql databases?



    thanks,
     
  2.  
  3. CBell

    CBell New Member

    Joined:
    Mar 3, 2003
    Messages:
    132
    Likes Received:
    0
    Occupation:
    Systems Analyst
    Location:
    Birmingham, AL
    In the TDPsql folder, there is a sqlfull.smp script that you can alter and save as a .cmd file to suit your needs. On the actual backup command in the script, I change the 'full' to 'log' and specify what option file I want the script to refer to. Then you can build a job on either the TSM server or from SQL Enterprise Manager, and set the schedule.
     

Share This Page