Can somebody recommend reliable sql backup software?

  • when i search "sql backup software" with google, there are many optional sql backup software there, i find difficult to choose one, so far, my consideration is between handy backup and easeus todo backup.

    handy backup is much more expensive than easeus todo backup

    has anybody ever used easeus todo backup? if it's professional, i think i will save a lot of money.

    ps: i found its advanced server edition at this website http://www.backup-sql-server.com

    i need advice please. a complete comparison between them will be better. thx

  • What's wrong with the native backups?

    Personally, if I was going to use a 3rd party tool, it'd be one of RedGate's SQL Backup solutions.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I've never heard of either of those backup softwares. Just curious, what is it that you're trying to get that you don't get using the native backup capabilities?

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • I know native backup capabilities can meet demand, but i am also curious that why there are still so many 3rd party tools there. I am afraid that I've missed something.

  • I've heard it before but never tried it

  • The 3rd party tools do stuff that the native doesn't or they do stuff the native does better or faster or easier.

    I ask because I'm the product evangelist for Red Gate Software. We have a couple of backup solutions that help lots of people, but I like to know what your'e looking for before I start talking about them in case there's another product elsewhere that can better fit your needs.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • If going 3rd party I would certainly go with Red-Gate. For the most part, I use the native tools though.

    I have tried several 3rd party tools and none compare to Red-Gate, imho.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Grant Fritchey (9/28/2011)


    The 3rd party tools do stuff that the native doesn't or they do stuff the native does better or faster or easier.

    I ask because I'm the product evangelist for Red Gate Software. We have a couple of backup solutions that help lots of people, but I like to know what your'e looking for before I start talking about them in case there's another product elsewhere that can better fit your needs.

    Absolutely, I know 3rd party backup tool and native has their merits and demerits, I wanna know the specific details. I am newbie to sql backup.

    And I am very sure that I just wanna choose between handy and easeus todo, since there are so many people recommend red gate here, somehow i feel a little uncomfortable on this sort of strong promotion.

  • OK I think I was just a little impulsive on my words, I'll learn more about redgate..

  • islandwino (9/28/2011)


    Absolutely, I know 3rd party backup tool and native has their merits and demerits, I wanna know the specific details. I am newbie to sql backup.

    Then you need to download demos of each tool and try them out. While some of us might have used one one other tool in the past we can't give you a comprehensive list of all the pros and cons of every tool out there. That's what demos and testing is for.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • islandwino (9/28/2011)


    Grant Fritchey (9/28/2011)


    The 3rd party tools do stuff that the native doesn't or they do stuff the native does better or faster or easier.

    I ask because I'm the product evangelist for Red Gate Software. We have a couple of backup solutions that help lots of people, but I like to know what your'e looking for before I start talking about them in case there's another product elsewhere that can better fit your needs.

    Absolutely, I know 3rd party backup tool and native has their merits and demerits, I wanna know the specific details. I am newbie to sql backup.

    And I am very sure that I just wanna choose between handy and easeus todo, since there are so many people recommend red gate here, somehow i feel a little uncomfortable on this sort of strong promotion.

    If you're just getting started, then yes, I can push Red GAte SQL Backup. It has an interface and a wizard that will walk you through setting up backups for your system, either for sets of databases or for individual databases. It has a lot of guidance and help so it'll walk you through what you need. Additionally, it has compression that works on all versions of SQL Server and, can compress better than SQL Server. It's a great piece of software. Further, you can try it out for free[/url].

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • there are many products as you know. For cost, ease of use and features i personally would go with Redgate SQLBackup. Having said that i'm currently using Quest LiteSpeed which is also a very good product.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I'm NOT a product evangelist for Red Gate... but I definitely like their backup tools. Restores with many log file backups are an absolute breeze which is especially good when you're doing "Point-in-time" backups every 15 minute or so. I point that out because it's not what you can backup that counts... it's what you can successfully restore that really counts.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • I personally like the compression that Redgate Backup provides. I also prefer restoring from Redgate over the native due largely to how much easier it is - as Jeff pointed out.

    But, compression in the native tools is good enough in many cases. And there are means to make restoring point in time faster and easier, via scripting, that make it more manageable with the native tools.

    Best advice is to test each of the tools and compare to find what you like - as Gail said.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Or just take time to learn the features of native SQL backup first before going into any third party route. SQL 2008 improved upon the older version with compression options.

    -------------------------------------------------
    Will C,
    MCITP 2008 Database Admin, Developer

Viewing 15 posts - 1 through 15 (of 16 total)

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