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

Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Restore Databases for Microsoft SQL Server 2014 AlwaysOn Availability Groups-MSSQLSvrW

Restore Databases for Microsoft SQL Server 2014 AlwaysOn Availability Groups-MSSQLSvrW

When restoring a Microsoft SQL Server 2014 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 2014 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.