Backup and Recovery Strategy
- Last UpdatedMay 17, 2023
- 1 minute read
All MES systems should have a good and validated backup and recovery strategy. For recommendations on creating a backup and recovery strategy, see MES Backup and Recovery Strategy.
Some key points are:
-
Have a local backup drive and store all your backups on it.
-
Use the correct SQL Server Recovery Model to match the backups you are doing.
-
Do complete backups at least once per day.
-
Implement truncation of transaction logs as part of the backup strategy to minimize the amount of storage they use.
-
Validate your backup/restore procedure.