Maintenance Plan
Last updated
Was this helpful?
Last updated
Was this helpful?
IMPORTANT When your Keyfax system(s) were installed, no SQL Database backup/maintenance plans were implemented; typically, this is the responsibility of your Database Administration Team.
We strongly recommend that your database(s) are backed up daily. The obvious reason is to prevent data loss, but performing regular backups will also ensure that the transaction log space used will be freed and reused, thus avoiding continuously auto growing the log file which can expand to such a size that performance is impacted and/or the SQL Server is in danger of running out of disk space. Backup is an important component of a sound disaster recovery strategy. Presence of a valid and restorable backup is the last thing you should worry about when the moment comes to execute a real disaster recovery scenario during an emergency downtime. Here are some best practices you can follow to ensure you have a good backup in place:
Make sure you are not storing your backups in the same physical location as the database files. When your physical drive goes bad, you should be able to use the other drive or remote location that stored the backups in order to perform a restore. Keep in mind that you could create several logical volumes or partitions from a same physical disk drive. Carefully study the disk partition and logical colume layouts before choosing a storage location for the backups.
Make sure you have a proper backup schedule established according to the needs of the application and business requirements. As the backups get old, the risk of data loss is higher unless you have a way to regenerate all the data till the point of failure.
Make sure to actually restore the backups on a test server and verify that you can restore with all the options and conditions you need to use during a planned or un-planned downtime.
Use the verification options provided by the backup utilities [BACKUP TSQL command, SQL Server Maintenance Plans, your backup software or solution, etc].
Use advanced features like BACKUP CHECKSUM to detect problems with the backup media itself.
There is a plethora of information and guidance on the internet. Be aware that descriptions will vary across versions of SQL Server®. For an Introduction to Backup and Restore Strategies in Microsoft SQL Server, . For an introduction to Maintenance Plans, . For video guidance on Creating a Backup Maintenance Plan, or for a step by step description of a robust Maintenance Plan, .