The end of last year I did a review on ApexSQL Restore, a tool used to attach SQL Server native backup files to a database instance. Check out the full review here if you missed it. Just last month (Aug 12th), ApexSQL released the newest version of ApexSQL Restore. This new version includes expanded functionality as a direct result of the feedback that they received from the community and my review. I always respect an organization that realizes the importance of reaching out to their customers and taking feedback to heart. So now I’d like to talk about their new features and how these changes relate to points that I addressed in my cons section of the original review.
Above are the three newest features released for ApexSQL Restore. As you may notice, they have included the ability to restore remote backups on to your local SQL Server machine. This was a con that I pointed out in my original review where I expressed a concern with the space usage and time-to-recovery when restoring backup files stored on a remote file share. The process of attaching remote files is identical to the process of attaching a local file with one exception. You will have to give your Windows credentials to reach the share to select the backup files.
While this may seem like a simple change, I was able to use this product to restore a 2 TB database, stored on a backup NAS, in less than a minute. This enabled me to immediately extract data from the backup without the need for local disk space to store the database or backup files.
Next we have new features. As you would expect, ApexSQL has updated the software to fully support SQL Server 2014. In addition, you can now restore to a specific point-in-time, very similar to how you would use the timeline feature in SQL Server Management Studio’s restore database wizard. ApexSQL Restore overall is very simple to use and very intuitive. With that being said, you can see below that the timeline interface is self-explanatory so I won’t use up anymore of your time with words.
In conclusion, I believe that this newest release of ApexSQL Restore is awesome. The remote backup support will make the difference between this tool being useful for mainly developers and it having a valid use case in disaster recovery.