ApexSQL Recover

If you're in need of a software solution for recovering lost data resulting from delete, truncate, or drop operations, ApexSQL Recover is a powerful tool to consider. With this program, you can also recover BLOB data as files and extract data from database backups without having to go through the process of restoring them.

ApexSQL Recover comes equipped with several useful features. For instance, it supports compressed backup files and uses smart resource management to optimize performance. Users can take advantage of direct-to-database recovery to recover data lost due to TRUNCATE or DROP operations, recover lost tables including those with missing schema or calculated columns, and extract online BLOBs as data files.

With advanced filtering options, ApexSQL Recover enables you to specify the timeframe for data or object loss. The software also supports additional SQL Server objects and data types, including vardecimal and FILESTREAM data. Importantly, ApexSQL Recover is compatible with all SQL Server databases from 2005 onwards, including SQL Server 2016 and Microsoft SQL Server 2017 CTP.

One key advantage of ApexSQL Recover is that it doesn't require any server-side components to be installed on the SQL Server itself. This means you can carry out data recovery without having to tinker with the server's configuration.

The software is also designed to handle multiple data source types, including live databases, detached database and transaction log files, and native or compressed transaction log and database backups. Furthermore, ApexSQL Recover can recover FileTables schema and data, and restore dropped objects.

Overall, ApexSQL Recover is an excellent choice for data recovery needs, offering powerful features while maintaining ease-of-use.