Post reply

SQL Server Backup Straight to TSM Yes/No

  • March 25, 2008 at 8:22 am

    #185476

    I am looking at several SQL Server backup softwares to backup SQL Server 2000/2005 on Windows 2003 servers. My company uses TSM to perform nightly file system backups currently. Several of the products I am looking at can backup databases directly to TSM. What are your opinions for or against backing up databases directly to TSM. I know for one, it is much slower to restore from TSM. Do any of you have any other technical reasons for or against TSM? Thanks for any input.

    -Kyle

  • March 25, 2008 at 9:10 am

    #793566

    Nope, don't do it. TSM will have a problem on the day you need to restore a database because someone (perhaps you) deleted a table by forgetting the WHERE clause.

    Back up to disk, preferably with a compression software (Red Gate, Quest, Idera, etc) and then let TSM grab to tape.

  • March 25, 2008 at 9:15 am

    #793570

    Thanks for your quick response, I am looking for reasons for or against it and that seems like a pretty good reason against TSM.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply