Database incremental backups
The following databases are backed up incrementally and uploaded to azure storage every 15 minutes:
| DB | Auto backup |
| BlocAdmin | Yes |
| BingoCampaign |
|
| BlocAPI | Yes |
| BlocSessionStateDB |
|
| BlocTempDB |
|
| BookCampaignDB | Yes |
| BookDB | Yes |
| brreg |
|
| Competition |
|
| Ecommerce |
|
| Elearning |
|
| InfoServer |
|
| Integrations | Yes |
| LogServer | Yes |
| NetsDB |
|
| NIFRestService |
|
| Orientering |
|
| NIFResultService |
|
| PaymentService | Yes |
| POS |
|
| SalesAdmin |
|
| Selskapsdata |
|
| SuperOfficeDB | Yes |
| TaskDB |
|
| Workouts | Yes |
|
|
We are using SqlBackupAndFtp to do DB backup auto,it will make full backup per 72 hours，diff backup per 24 hours, trans logs per 15 mins,and all backups will upload to Azure storage "blocdbbackup"
For restore
1. Download the last fullbackup
2. Download last diff backup
3. Download all trans logs after last diff backup
4.
RESTORE DATABASE FROM full_database_backup WITH NORECOVERY;
GO
RESTORE DATABASE FROM differential_backup WITH NORECOVERY;
GO
RESTORE LOG FROM log_backup WITH NORECOVERY;
GO
-- Repeat this until you restore last log backup
RESTORE DATABASE WITH RECOVERY;
GO
