Previous Topic: Perform an Online Torn Page Restore Using Microsoft SQL Server 2000, 2005, 2008, or 2012 Enterprise, Data Center, or Developer EditionsNext Topic: Backing Up and Restoring in Cluster Environments

Restoring Microsoft SQL Server Databases › Restore Databases for Microsoft SQL Server 2012 AlwaysOn Availability Groups

Restore Databases for Microsoft SQL Server 2012 AlwaysOn Availability Groups

When restoring a Microsoft SQL Server 2012 database that is part of an AlwaysOn Availability Groups (AAG), there are some considerations that you should be aware of.

If the Microsoft SQL database is part of the Microsoft SQL 2012 AlwaysOn Availability Groups (AAG), and restoring to the original location fails, perform the following tasks:

  1. Remove the database to be restored away from the Availability Groups. For more information, see http://msdn.microsoft.com/en-us/library/hh213326.aspx.
  2. Use the Restore Manager to restore the database to all nodes in the AAG group.
  3. Add the database back to the Availability Groups. For more information, see http://msdn.microsoft.com/en-us/library/hh213078.aspx.