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)
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,1 @@ 1 -MI Restore to Staging From Live1 +MI Restores - Content
-
... ... @@ -1,28 +1,0 @@ 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, delete encrpytion key for DB 7 -111. TODO move to self managed keys 8 -11. enable compression! 9 -11. container for client 10 - 11 -1. Drop Old DB 12 -11. drop existing connections 13 - 14 -1. Restore DB from Live from last PITR 15 - 16 -1. Run post restore access script sqlmi_accesss_SKL.sql 17 -11. [TODO] source passwords from vault 18 -11. set clearLogins = 1 19 -11. TODO 20 - 21 -1. Run dba.dbo.sp_scan_db script for '%[_]Live[_]%' 22 -11. correct all config found and repoint to Staging 23 -11. TODO automate 24 - 25 -1. Start all services 26 -11. check logs to make sure no connections issues 27 - 28 -