MI Restore

Version 1.5 by Rudi Marais on 2024/05/13 12:33

 

  1. Backup Old DB to storage account
    1. container for client
       
  2. Stop all services including web site
     
  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. 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: