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

<
From version < 1.21 >
edited by Rudi Marais
on 2024/05/13 14:26
To version < 1.16 >
edited by Rudi Marais
on 2024/05/13 14:15
>
Change comment: (Autosaved)

Summary

Details

Page properties
Content
... ... @@ -3,7 +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
6 +11. disable encryption if enabled, delete encrpytion key for DB
7 7  111. TODO move to self managed keys
8 8  11. enable compression!
9 9  11. container for client
... ... @@ -13,17 +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. Give yourself access to the admin group via the powershell script
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]]
16 +1. Run post restore access script sqlmi_accesss_SKL.sql
21 21  11. [TODO] source passwords from vault
22 22  11. set clearLogins = 1
23 23  11. TODO
24 24  
25 -1. TODO - post restore script db sedttings etc
26 -
27 27  1. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
28 28  11. correct all config found and repoint to Staging
29 29  11. TODO automate

Need help?

If you need help with XWiki you can contact: