News & Events

SQL Server 2012 – Database Recovery Advisor

There are a number of fantastic enhancements and features available in Microsoft SQL Server 2012, one particular new feature being the Database Recovery Advisor.

This new feature provides useful administrative functionality, which is especially useful for junior DBAs or those not very familiar with T-SQL restoration method. What this is handy about this tool, is that is visually displays the transaction log back-ups available for restoration. This is useful for taking the burden away from analysing database log chain, and working out the sequence of the LSNs for a transaction log restore.

The Database Recovery Advisor is a fantastic new tool, released with SQL Server 2012. It is a GUI extension of the restore process in SQL Server management studio. It provides the function to visually set a time line restoration for a database. SQL Server will determine the historic time line, for how far back a database can be recovered from the available full; differential and transaction log backups it has. Once the restoration point has been selected, the wizard to automatically grab the available backups to restore.

The DRA is available in all versions of SQL Server 2012. The benefits of using the tool are that:

• The DBA will be able to visually and accurately predict a SQL database restoration.

• Reduce the amount of time the DBA uses to manually link the transaction log backup files together, for restoration.

The Database Recovery Advisor is a handy tool for any DBA to have in their back pocket. For a DBA to be able to reduce the lead time for restoring production databases it will allow for databases that do not have a high availability solution implemented, to react faster to data recovery situations.

Get in touch

For more information or to schedule a demo please contact us

Contact us


DSP winners at the UK Oracle User Group Awards 2017/18

DSP attended the UK Oracle User Group Partner of the Year Awards last week, and we came away with awards for both categories in which we were nominated

Read more
View All


"Self Managing Databases: Fable, Fantasy or the Future"

Join us for lunch and to hear some war stories from staff and customers with experience of Oracle Database Cloud Service. We'll also understand more about the Autonomous Database and how Oracle will compete with AWS.

Read more
View All


Why is modernizing your Security key for a move to the Cloud?

Don't compromise when it comes to the security of your data: discover the key to capitalizing on your migration into Public Cloud.

Read more
View All