Dev Team Portal

Appearance

Database Disaster Recovery Plan ​

Restore database ​

  • EC2: launch "DB" instance from Launch Templates
  • DB BACKUP: check latest D:\TicketSource\dbbackup\ticketsource.db is in X:\TicketSource\db
  • DB BACKUP: check latest D:\TicketSource\dbbackup\ticketsource.log is in X:\TicketSource\db
  • DB BACKUP: copy live transaction log D:\TicketSource\dbbackup\ticketsource1.log to X:\TicketSource\db
  • EC2: detach volume "DB Backup (DB (D:))" from "DB Backup" instance
  • EC2: attach volume "DB Backup (DB (D:))" to "DB" instance as D:
  • EC2: attach volume "DB Backup (DB (E:))" to "DB" instance as E:
  • EC2: attach volume "DB Backup (DB (F:))" to "DB" instance as F:
  • DB: apply full backup transaction log and differental transaction log to restored database => dbeng17.exe d:\ticketsource\db\ticketsource.db -ep -ad d:\ticketsource\db
  • DB: SQL Central -> Start "TicketSource" service
  • DB: delete D:\TicketSource\db\ticketsource.log
  • DB: delete D:\TicketSource\db\ticketsource1.log

Restore session database ​

  • DB: Run as Administrator => C:\TicketSource\db-session-cleandb\initSessionDB.bat