Labels

Tuesday, 14 March 2017

How to restore database in AG



ü  Backup the exisitng  dataabse
ü  Take the security backup
ü  Remove the databases from availability group : AlwaysOn High Availability --> Availability Groups
è Group Name Ex:AG_Test -->Availability Databases --> DatabaseName
--> Remove Database Name from Availability Group
ü  Restore the databases
ü  Execute the security permissions ( which you have taken before restore) on newly restored database.
ü  Remove the availability databases on secondary
ü  Add the databases to the Availability group

No comments:

Post a Comment