In the event of catastrophic failure, there are several options to minimize data loss
Securing Your Data
- RAID capable server
- Backups are copied to a network/cloud location
- Regular snapshots of the server/VM
Default Backup Location
C:\Program Files\Microsoft SQL Server\MSSQLxx.AURORA\MSSQL\Backup\
Changing the default backup location may result in backup failures
Ensure location and permissions are valid by checking on backups regularly
Immediate Backup
- Select Settings
- Select Database Maintenance
- Click Backup Now
- Click Yes
- Click OK once finished
Schedule Backup
- Select Settings
- Select Database Maintenance
- Select Scheduled Backup tab
- Enter/Select the desired settings
- Email will only work if SMTP is setup
- Click Save once finished
Restoring A Backup
Follow the restore steps in the following article to restore a backup