Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Smile Unanswered: Using 3rd party software for SQL Server backups

    Has anyone had experience using ‘VERITAS Backup Exec For Windows Servers Agent for MS SQL Server’ to run backup jobs? If so, what are the pros and cons?

    I have always preferred using SQL Server Agent (not the maintenance plans) to run backup jobs and don’t know why anyone would want to use 3rd party software to do something SQL Server Agent does perfectly. Any advice?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I think BACKUP EXEC is an overkill for a shop with a good DBA, and a total waste of money where there is a great DBA. If you know how and what it tries to do, you'd agree. We use maintenance plans extensively here, but we don't even create them with the wizard, - everything with scripts. No jobs result from it, just 3 that run on every server (system db backups, trx log backups, and full backups.)
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    Originally posted by rdjabarov
    I think BACKUP EXEC is an overkill for a shop with a good DBA, and a total waste of money where there is a great DBA. If you know how and what it tries to do, you'd agree. We use maintenance plans extensively here, but we don't even create them with the wizard, - everything with scripts. No jobs result from it, just 3 that run on every server (system db backups, trx log backups, and full backups.)
    Thanks for your input. I totally agree with you. I imagine that the product clumsily logs on to SQL Server (with lots of power), and runs the same scripts we run. I see no advantage--just an invasion--putting the rest of SQL Server in jeopardy. I can't imagine why anyone would want that.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    rdjabarov, it frightens me that I've agreed with the last half-dozen posts you've made.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    [fake_texan_accent]
    Yup, something's in the air, hey?!
    [/fake_texan_accent]
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Holy Sh-t

    Someone take a peek at hell...they skiing down there?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    They're drinkin' frozen margaritas.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734

    Re: Using 3rd party software for SQL Server backups

    Originally posted by suzydba
    Has anyone had experience using ‘VERITAS Backup Exec For Windows Servers Agent for MS SQL Server’ to run backup jobs? If so, what are the pros and cons?

    I have always preferred using SQL Server Agent (not the maintenance plans) to run backup jobs and don’t know why anyone would want to use 3rd party software to do something SQL Server Agent does perfectly. Any advice?
    I've been forced to use it before. After spending several weeks fixing things everytime something broke, I wrote my own process and never had to think about it again. The product sucks with SQL Server (my own humble opinion of course).
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  9. #9
    Join Date
    Mar 2004
    Posts
    4
    Thanks for your input. I suspected as much.

Posting Permissions

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