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, 1 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. phillips1 +XWiki.nikhils - Content
-
... ... @@ -1,19 +1,19 @@ 1 1 2 2 3 -1. Pull newest scripts from repo using D:/ebsphere/devops/setup-new.ps1 4 - 3 +1. Pull newest scripts from repo using D:/ebsphere/devops/setup-scripts/setup-new.ps1 5 5 1. Stop all services including web site for staging on VM 6 6 7 7 1. Drop Old DB on Azure portal 8 8 11. drop existing connections 9 9 10 -1. Restore DB from Live from last PITR 11 - 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"]] 12 12 1. Give yourself access to the admin group via the powershell script - if needed 13 13 14 14 1. Wait for group policy SQL JOB [roughly 5-10 minutes] to create groups 15 15 16 16 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,0 +1,1 @@ 1 +XWiki.nikhils - Size
-
... ... @@ -1,0 +1,1 @@ 1 +67.7 KB - Content