Version 3.1 by Rudi Marais on 2024/05/17 12:20
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. Give yourself access to the admin group via the powershell script
17
18 1. Wait for group policy SQL JOB [roughly 5-10 minutes] to create groups
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 = 2
23 11. TODO
24
25 1. TODO - post restore script db settings etc
26 11. recreate tblDocuments synonym
27
28 1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
29 11. correct all config found and repoint to Staging
30 11. TODO automate
31
32 1. Start all services
33 11. check logs to make sure no connections issues
34
35