Skip to content

Cloud SQL Manual Database backups

Manual Backups and Restore process

  1. Database export ➝ bucket\backup
    • Stable SQL ➝ export
      • choose wanted database
      • select destination ➝ name backup e.g. Backup_before_Release_DDMMYY etc.
    • pick destination bucket: e.g. ao_db_live/backup
  2. Import database ➝ bucket/backup
    • Stable SQL ➝ import
      • choose exported database
      • name it
    • To deploy:
      • shutdown servers, services and kick out clients
    • In MSSQL add user and rename old and new database
      • Check connection with IdAdmin.exe
      • Start Service and servers

Manual backup of Cloud SQL Instance

    1. In GCP select wanted resource e.g. stable-databases-01 go to SQL ➝ Backups ➝ create backup 1. Then you can restore one or more databases
  2. Automated backups will be taken every day (need to change automation time)