Version 1.20 by Rudi Marais on 2024/05/13 14:25
Show last authors
1
2
3 1. Stop all services including web site for staging on VM
4
5 1. Backup Old DB to storage account
6 11. disable encryption if enabled, delete encryption key for DB
7 111. TODO move to self managed keys
8 11. enable compression!
9 11. container for client
10
11 1. Drop Old DB
12 11. drop existing connections
13
14 1. Restore DB from Live from last PITR
15
16 1. Wait for group policy SQL JOB [roughly 5-10 minutes] to create groups
17
18 1. Give yourself access via the powershell script
19
20 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]]
21 11. [TODO] source passwords from vault
22 11. set clearLogins = 1
23 11. TODO
24
25 1. TODO - post restore script db sedttings etc
26
27 1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
28 11. correct all config found and repoint to Staging
29 11. TODO automate
30
31 1. Start all services
32 11. check logs to make sure no connections issues
33
34