Changes for page MI Restore to Staging From Live
Last modified by Phillip Swanepoel on 2026/06/09 12:46
Change comment:
(Autosaved)
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,1 @@ 1 -MI Restore s1 +MI Restore to Staging From Live - Content
-
... ... @@ -1,0 +1,26 @@ 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 7 +11. container for client 8 + 9 +1. Drop Old DB 10 +11. drop existing connections 11 + 12 +1. Restore DB from Live from last PITR 13 + 14 +1. Run post restore access script sqlmi_accesss_SKL.sql 15 +11. [TODO] source passwords from vault 16 +11. set clearLogins = 1 17 +11. TODO 18 + 19 +1. Run dba.dbo.sp_scan_db script for '%[_]Live[_]%' 20 +11. correct all config found and repoint to Staging 21 +11. TODO automate 22 + 23 +1. Start all services 24 +11. check logs to make sure no connections issues 25 + 26 +