1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

TDP for microsoft SQL Server (log backups)

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

  1. DavidLust

    DavidLust ADSM.ORG 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 ADSM.ORG 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