Backup and recovery strategies
- Last UpdatedOct 22, 2024
- 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 strategies.
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.