Version 1.16 by Rudi Marais on 2024/05/13 14:15
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 encrpytion 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. Run post restore access script sqlmi_accesss_SKL.sql
17 11. [TODO] source passwords from vault
18 11. set clearLogins = 1
19 11. TODO
20
21 1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
22 11. correct all config found and repoint to Staging
23 11. TODO automate
24
25 1. Start all services
26 11. check logs to make sure no connections issues
27
28