SQL Server 2012 is a vast release that includes many new features. Members of the SQL Server community have great insights into these new features and can help you decide if SQL Server 2012 is for you.
One such feature is the Database Recovery Advisor, and Basit Farooq gives his evaluation of this feature, as well as useful tips in his article at http://basitaalishan.com/2012/09/19/database-recovery-advisor-feature-of-sql-server-2012.
Basit opens his review by noting, “SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases with SQL Server Management Studio. As we know, SQL Server provides a variety of backup types, so creating the proper recovery sequence for each point in time can be tricky at times. This is where Database Recovery Advisor is useful, because it makes the database restoration process more agile by helping the customers to create more predictable and optimal recovery sequence.”
Check out Basit’s review and let us know if you would find the Database Recovery Advisor a compelling reason to upgrade to SQL Server 2012.