Home Forums SQL Server 2017 SQL Server 2017 - Administration Backing up multiple SQL instance and databases using 3rd party software - Any recommendations RE: Backing up multiple SQL instance and databases using 3rd party software - Any recommendations

  • Steve Jones - SSC Editor - Wednesday, November 22, 2017 4:36 PM

    Jeff Moden - Wednesday, November 22, 2017 2:34 PM

    You won't find better backup and faster restore times than the native methods.  3rd party backup tools just make it all a bit easier for people that need it to be easier.

    As for a "centralized software management tool" that does this, let me ask.... If you're in a DR situation and trying to get back in business quickly and restores are the only hope left to do so, what are you going to do if your  "centralized software management tool" was a casualty of whatever went wrong?

    That's not quite true. Compressed backups and restores can be faster, depending on your CPU/IO systems.

    As for central servers, SQL Backup can be easily setup  and instances added back. Or a restore of the system. We also include utilities in extreme cases to convert our compressed backups to native formats.

    +1
    In fact, Litespeed also has disk and network resilience options so that when restoring across a network for instance, it will retry lost buffers and increase the chance of a successful operation, where native will just crap out with a rather long MS error message 😀

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

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