This post like many other is for self reference. I recently had a requirement to restore a UAT model to a prod environment and prod was running as a sql cluster. The steps I followed are
1)Remove the db from availability group of primary
2)do the restore to the prod as usual
3)Delete db from the secondary server instance. Yup delete it as it will be restored from the primary
4)Change recovery mode to full mode from properties->Options
5)Take backup
6)Add database to availability group
7) Make sure you have access to the staging path, which needs to be a shared location accessible by both servers
8)Press next next and ok.
1)Remove the db from availability group of primary
2)do the restore to the prod as usual
3)Delete db from the secondary server instance. Yup delete it as it will be restored from the primary
4)Change recovery mode to full mode from properties->Options
5)Take backup
6)Add database to availability group
7) Make sure you have access to the staging path, which needs to be a shared location accessible by both servers
8)Press next next and ok.
No comments:
Post a Comment