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 s1 +MI Restore - Content
-
... ... @@ -1,0 +1,25 @@ 1 + 2 + 3 +1. Backup Old DB to storage account 4 +11. container for client 5 + 6 +1. Stop all services including web site 7 + 8 +1. Drop Old DB 9 +11. drop existing connections 10 + 11 +1. Restore DB from Live from last PITR 12 + 13 +1. Run post restore access script sqlmi_accesss_SKL.sql 14 +11. source passwords from vault 15 +11. set clearLogins = 1 16 +11. TODO 17 + 18 +1. Run dba.dbo.sp_scan_db script for '%[_]Live[_]%' 19 +11. correct all config found and repoint to Staging 20 +11. TODO automate 21 + 22 +1. Start all services 23 +11. check logs to make sure no connections issues 24 + 25 +