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 (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,12 +1,13 @@ 1 1 2 2 3 -1. Pull newest scripts from repo using D:/ebsphere/devops/setup-scripts/setup-new.ps1 3 +1. Pull newest scripts from repo using D:/ebsphere/devops/setup-new.ps1 4 + 4 4 1. Stop all services including web site for staging on VM 5 5 6 6 1. Drop Old DB on Azure portal 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 important10 +1. Restore DB from Live from last PITR 10 10 11 11 1. Give yourself access to the admin group via the powershell script - if needed 12 12 ... ... @@ -13,7 +13,6 @@ 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