Version 9.1 by Phillip Swanepoel on 2025/03/17 12:42
Show last authors
1
2
3 1. Pull newest scripts from repo using D:/ebsphere/devops/setup-scripts/setup-new.ps1
4 1. Stop all services including web site for staging on VM
5
6 1. Drop Old DB on Azure portal
7 11. drop existing connections
8
9 1. Restore DB from Live from last PITR or latest Full backup if DB age is not important
10
11 1. Give yourself access to the admin group via the powershell script - if needed
12
13 1. Wait for group policy SQL JOB [roughly 5-10 minutes] to create groups
14
15 1. Run post restore access script [[SKL_sqlmi_accesss.sql - Repos (azure.com)>>url:https://dev.azure.com/ebsphere/ebsphere/_git/dbs?version=GBmaster&path=/src/setup_scripts/SKL_sqlmi_accesss.sql]]
16 11. [TODO] source passwords from vault
17 11. set clearLogins = 2
18 11. TODO
19
20 1. TODO - post restore script db settings etc
21 11. recreate tblDocuments synonym
22 11. tblAudit if applicable
23
24 1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
25 11. correct all config found and repoint to Staging
26 11. TODO automate (some of the config correcting statements can be generated using [dba].[devops].[sp_change_db_env_post_restore])
27 1. Start all services
28 11. check logs to make sure no connections issues
29
30