MI Restore

Version 1.3 by Rudi Marais on 2024/05/13 12:27

 

  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 script sqlmi_post_restore_SKL
    1. source passwords from vault
       
  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: