SQL Server – Adding a Database to AlwaysOn Availability Group

I usually restore the backup file to the secondary replica WITH NORECOVERY state before I add database to AlwaysOn Availability Group (AAG).

 

The following are the steps to add a​​ database to AAG.

 

 

  • Expand​​ Availability Groups. Right-click​​ Availability Database. Choose​​ Add Database.

 

 

 

  • Click​​ Next.

 

 

 

  • Tick the database that you want to add. You will notice that under status​​ columm, the message is “Meets​​ prerequisites”. This is because I have already restored the database with norecovery status in the secondary replica.

 

 

 

 

  • Choose​​ Join Only.

 

 

 

  • Connect​​ to existing secondary replicas.

 

 

 

 

  • Click​​ Next.

 

 

 

 

  • Click​​ Finish.

 

 

 

 

  • Click​​ Close.

 


 

]

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *