Things to consider while defining the backup strategy
The following are the considerations for defining a backup strategy:
Prepare a disaster recovery plan for the organization.
Consider doing a backup before any major development code promotion to the database, deleting, modifying, optimizing, and expanding the database.
Select the appropriate SQL database recovery model.
Plan to include all possible failures, including a complete loss of the physical server and/or media failure.
System databases of SQL Server should also be backed up.
A quarterly check of the restore of the backup to make sure the backups are not corrupt.
The backup location must be physically different from our data location.
A daily backup of the complete database is ideal. In the case of larger databases with lots of transactions, a differential/incremental backup can suffice.
Also, back up the transaction log if using SQL Server for Microsoft Dynamics NAV.
