About SQL SERVER Alwayon database restore operations

About SQL SERVER Alwayon database restore operations

Ideas:

In practice and in conjunction with related documentation, it is broadly divided into four steps:

First step: Remove the db that needs to be restored from the availability group, (at which point the primary database will be stateless, the secondary database is being restored ...). State

The second step: in the primary replica database, restore the database, if only full backup restore, the default parameters can be, if you need further log restore after a full restore, select the WITH NORECOVERY option;

Step three: Delete the DB that needs to be restored in the secondary replica database;

Fourth step: In the Availability group, add the database you just restored to the availability group;

Once the above operation is complete, the database is in a synchronized state.

This article is from the "brave" blog, make sure to keep this source http://brave8898.blog.51cto.com/289041/1967230

About SQL SERVER Alwayon database restore operations