Version 1.19 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. 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]]
19 11. [TODO] source passwords from vault
20 11. set clearLogins = 1
21 11. TODO
22
23 1. TODO - post restore script db sedttings etc
24
25 1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
26 11. correct all config found and repoint to Staging
27 11. TODO automate
28
29 1. Start all services
30 11. check logs to make sure no connections issues
31
32