OVERVIEW

This page will explain the steps to be followed when restoring a database

HOW TO

Copy backup file from Z:\Devs\JeremyF\Data folder of remote environment

1. If today's backup file is needed reach out to Jeremy Ferrante and request they sync it to the QA machine being refreshed.
   
2. Paste backup file to E:\DB\ of remote environment
   1. If there is no available space, delete the existing backup file prior to pasting new backup file
3. Open Notepad
4. Click File > Open
5. Click Text Documents (*.txt) and select All Files (*.*)
   
6. Scroll down the list and double-click db_restore.sql
   
7. Ctrl+A + Ctrl+C to copy all of db restore file
   
8. Open Microsoft SQ Server
9. In left menu, click Databases > Database Snapshots
10. Right click + Delete the existing snapshot
    
11. Click OK button
12. Click New Query button
    
13. Ctrl+V to paste db restore file from Notepad
14. Click Execute button
    
15. Process takes from 45 minutes to 90 minutes dependent upon remote environment
    1. The messages tab will populate with progress updates throughout the process
       
16. Once the Query finishes running, contact a member of the QA team and request they ship the latest dev branch to the QA machine.
17. Update the QA Slack channel description for the QA machine with the date of the data used for the refresh.