MI Restore to Staging From Live

Version 4.1 by Rudi Marais on 2024/05/17 12:21

 

  1. Stop all services including web site for staging on VM
     
  2. Backup Old DB to storage account
    1. disable encryption if enabled, delete encryption key for DB
      1. TODO move to self managed keys
    2. enable compression!
    3. container for client
       
  3. Drop Old DB
    1. drop existing connections
       
  4. Restore DB from Live from last PITR
     
  5. Give yourself access to the admin group via the powershell script
     
  6. Wait for group policy SQL JOB [roughly 5-10 minutes] to create groups
     
  7. Run post restore access script SKL_sqlmi_accesss.sql - Repos (azure.com)
    1. [TODO] source passwords from vault
    2. set clearLogins = 2
    3. TODO
       
  8. TODO - post restore script db settings etc
    1. recreate tblDocuments synonym
    2. tblAudit if applicable
       
  9. Run  dba.dbo.sp_scan_db script for '%[_]Live[_]%'
    1. correct all config found and repoint to Staging
    2. TODO automate
       
  10. Start all services
    1. check logs to make sure no connections issues

 

Tags: