MI Restore to Staging From Live

Version 1.9 by Rudi Marais on 2024/05/13 13:53

 

  1. Stop all services including web site for staging on VM
     
  2. Backup Old DB to storage account
    1. container for client
       
  3. Drop Old DB
    1. drop existing connections
       
  4. Restore DB from Live from last PITR
     
  5. Run post restore access script sqlmi_accesss_SKL.sql
    1. [TODO] source passwords from vault
    2. set clearLogins = 1
    3. TODO
       
  6. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
    1. correct all config found and repoint to Staging
    2. TODO automate
       
  7. Start all services
    1. check logs to make sure no connections issues

 

Tags: