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.
Leave a Reply