Last modified by Phillip Swanepoel on 2026/06/09 12:46

<
From version < 1.19 >
edited by Rudi Marais
on 2024/05/13 14:25
To version < 1.14 >
edited by Rudi Marais
on 2024/05/13 14:10
>
Change comment: (Autosaved)

Summary

Details

Page properties
Content
... ... @@ -3,9 +3,7 @@
3 3  1. Stop all services including web site for staging on VM
4 4  
5 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!
6 +11. disable encryption if enabled
9 9  11. container for client
10 10  
11 11  1. Drop Old DB
... ... @@ -13,15 +13,11 @@
13 13  
14 14  1. Restore DB from Live from last PITR
15 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]]
14 +1. Run post restore access script sqlmi_accesss_SKL.sql
19 19  11. [TODO] source passwords from vault
20 20  11. set clearLogins = 1
21 21  11. TODO
22 22  
23 -1. TODO - post restore script db sedttings etc
24 -
25 25  1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
26 26  11. correct all config found and repoint to Staging
27 27  11. TODO automate

Need help?

If you need help with XWiki you can contact: