Please find below very smile 6 step to Restore the New or suspected database in Always-on
1. Open SSMS à Connect to Primary availability group Server (Server1) à explore Availability databases à Right click and remove
the database<DB1>.
2. Refresh instance à you will see the removed database<DB1> will not
be available in Primary availability database group à Go to the
databases (Here the Synchronized
status will be removed) à Now restore the Full
backup file with Recovery mode and
with Replace option.
3. Now Connect to
the Secondary Availability
Group Server(Server2) à Go to the databases and restore the database<DB1.bak> with No Recovery
option, also restore the T. log<DB1.trn>
backup of the database.
4. Now again Connect
to Primary availability group
Server à Right Click on Availability
database and click on ADD database
option à Select your Restored
database <DB1> à select the any one Initial data synchronization mode
<Full, Join Only> à Next à click on Connect button, to
connect Secondary replica <Server2> à Validation à Next à Summary à Next à Result.
5. Now refresh your
both Servers instance and see on the Primary Server, database<DB1> should
be in Synchronized state and on the
secondary server, database should be in Synchronizing
state.
Please let me know if you have any other step to do the same. - Jainendra Verma
No comments:
Post a Comment