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

From version < 1.16 >
edited by Rudi Marais
on 2024/05/13 14:15
To version 1.1 >
edited by Rudi Marais
on 2024/05/13 12:20
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -MI Restore to Staging From Live
1 +MI Restores
Content
... ... @@ -1,28 +1,0 @@
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 -

Need help?

If you need help with XWiki you can contact: