Version 1.14 by Rudi Marais on 2024/05/13 14:10
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
7 11. container for client
8
9 1. Drop Old DB
10 11. drop existing connections
11
12 1. Restore DB from Live from last PITR
13
14 1. Run post restore access script sqlmi_accesss_SKL.sql
15 11. [TODO] source passwords from vault
16 11. set clearLogins = 1
17 11. TODO
18
19 1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
20 11. correct all config found and repoint to Staging
21 11. TODO automate
22
23 1. Start all services
24 11. check logs to make sure no connections issues
25
26