Changes for page MI Restore to Staging From Live
Last modified by Phillip Swanepoel on 2026/06/09 12:46
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
-
Attachments (0 modified, 0 added, 1 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. nikhils1 +XWiki.phillips - Content
-
... ... @@ -1,19 +1,24 @@ 1 1 2 2 3 -1. Pull newest scripts from repo using D:/ebsphere/devops/setup- scripts/setup-new.ps13 +1. Pull newest scripts from repo using D:/ebsphere/devops/setup-new.ps1 4 4 1. Stop all services including web site for staging on VM 5 5 6 -1. Drop Old DB on Azure portal 6 +1. Backup Old DB to storage account 7 +11. disable encryption if enabled, delete encryption key for DB 8 +111. TODO move to self managed keys 9 +11. enable compression! 10 +11. container for client 11 + 12 +1. Drop Old DB 7 7 11. drop existing connections 8 8 9 -1. Restore DB from Live from last PITR or latest Full backup if DB age is not important 10 -- [[image:image-20250411144502-1.png||height="150" width="284"]] 11 -1. Give yourself access to the admin group via the powershell script - if needed 15 +1. Restore DB from Live from last PITR 12 12 17 +1. Give yourself access to the admin group via the powershell script 18 + 13 13 1. Wait for group policy SQL JOB [roughly 5-10 minutes] to create groups 14 14 15 15 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 -11. This has to be run using SQLCMD mode on the script 17 17 11. [TODO] source passwords from vault 18 18 11. set clearLogins = 2 19 19 11. TODO
- image-20250411144502-1.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.nikhils - Size
-
... ... @@ -1,1 +1,0 @@ 1 -67.7 KB - Content