Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Dec 2004
    Location
    hawaii
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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. #2
    Member
    Join Date
    Mar 2003
    Location
    Birmingham, AL
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

Similar Threads

  1. TDP for SQL Server - restoring Database to another server
    By director_den in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 09-30-2011, 06:44 AM
  2. Replies: 0
    Last Post: 09-13-2006, 09:29 AM
  3. Unable to Restore-No Errors at All
    By khurana5 in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 05-04-2006, 07:02 AM
  4. SQL Plugin for TSM?
    By CHund in forum Backup / Archive Discussion
    Replies: 5
    Last Post: 08-19-2005, 10:57 AM
  5. " ANS1302E No objects on server match query " on SQL backup
    By tom.s in forum TDP/Application Layer Backup
    Replies: 0
    Last Post: 05-09-2005, 08:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •