Does anyone have Enterpise experience using IDERA SQL Safe Backup? Any pro's or con's of using it? I am trying to find a backup and restore tool for my team to use. Any suggesstions are appreciated.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by red68 · Oct 08, 2018 at 08:17 PM
We have been using Idera SQL Safe Backup for years without a hiccup. I have used the restore option as well and it worked perfectly. We perform daily incremental backups and weekly full backups.
Answer by Wnorris22 · Oct 09, 2018 at 04:53 PM
Thanks red68. How many servers are you monitoring? Have you used the object level restore?
We actually used Idera Virtual Database to restore object level like a table if it was accidentally deleted. SQL Virtual Database is driven by a unique, patent-pending recovery technology that makes backup files behave like regular physical databases. This technology allows you to create virtual databases by directly attaching backup files to SQL Server without requiring a restore operation.
Each virtual database is hosted by the SQL Server instance you specify. All objects and data in the virtual databases are accessible to SQL Server jobs and stored procedures, T-SQL scripts, and other third-party applications. I would then restore just the table to the production database and you would be back up and running. Hope this helps.
Answers Answers and Comments
19 People are following this question.
2008R2 Restore *.bak Header failure
Does anyone know of any good backup/restore tools?
Point in Time Restore Problem