Skip to content

Latest commit

 

History

History
46 lines (43 loc) · 2.41 KB

Database-Backups.md

File metadata and controls

46 lines (43 loc) · 2.41 KB

Performing Manual Database Backups and Restores

Backup Database

  1. Connect to Database Pod
  2. Open Data management tool to the table such as Sql Server Management Studio (SSMS) or Azure Data Studio (ADS)
  3. On SSMS
    • Right-Click on Database and select Tasks -> Backup Database smss-backup
    • Ensure Database is selected as a Backup component:
    • Select Destination as a Back up to: Disk and click Add smss-backup
    • In the popup, enter the file name, then click Ok* Then click Ok on the main Backup Up Database window

    On ADS * Right-Click on Database and select **Backup** ![smss-backup](./resources/ads-backup.png) * Enter a Backup Name * Remove the current backup file by selecting and clicking "-", then click "+" to enter a new specific backup file * Click **Backup** button ![smss-backup](./resources/ads-backup-2.png)

Restore Database

  1. Connect to Database Pod

  2. Open Data management tool to the table such as Sql Server Management Server (SSMS) or Azure Data Studio (ADS)

  3. On SSMS

    • Right click on Database and select Tasks -> Restore -> Database smss-backup
    • On the General page select Device, then click '...' button
    • Click the Add button and enter a file name smss-backup
    • Next click the Options Page
    • Ensure that Overwrite the existing database is selected Restore Options
    • As well, under Server Connections, select Close existing connections to the database
    • Click Ok and then Ok on the the main restore window smss-backup

    On ADS

    • Right-Click on Database and select Restore smss-backup
    • Ensure Backup file is selected under Source
    • Click the "..." button to select the backup file
    • Next click the Options Page
    • Ensure that Overwrite the existing database is selected under Restore Options
    • As well, under Server Connections, select Close existing connections to the database
    • Click the Restore button smss-backup