Home » SQL Server » SQL Server 2012 – Database Recovery Advisor

SQL Server 2012 – Database Recovery Advisor


With the introduction of the Database Recovery Advisor, restoring databases to a point in time will be made much easier. SQL Server provides a variety of backup types & creating the right recovery sequence for any point in time can get tricky. To help make this process much more streamlined, SQL Server 2012 introduces a new Recovery Advisor to help DBA to create a more predictable and optimal restore sequence.

It has Capabilities include a visual timeline that presents the backup history of the database and the available points in time to which the user can restore the database. Although DBA can do all these task by scripts but using a GUI for restore & selecting recovery sequence is quite useful & handy.

Advertisements

1 Comment

  1. Adam Gorge says:

    This is one of the best feature of SQL Server 2012. This new feature of SQL Server 2012 simplify the database restoring process to a point in time, or performing incremental restore operations to determine the timeframe when a problem first occurred. In case this feature is unable to repair corrupt SQL Server database then you can use third party SQL Recovery Software. Stellar Phoenix SQL Recovery Software is one of the best tool!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: