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,13 +1,12 @@ 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 9 +1. Restore DB from Live from last PITR or latest Full backup if DB age is not important 11 11 12 12 1. Give yourself access to the admin group via the powershell script - if needed 13 13 ... ... @@ -14,6 +14,7 @@ 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