SQL Server maintenance plans
Backup strategy
Standard enterprise filesystem backup software typically cannot safely back up live, active SQL Server databases. Unless your backup infrastructure explicitly features a SQL Server-aware agent, you must configure an internal Microsoft SQL Server Maintenance Plan.
Frequency Requirement: The ThoughtFarmer database must be backed up at least once every 24 hours.
Transaction Logs: If your organization requires a Full recovery model, you must also schedule a daily (or more frequent) transaction log backup to prevent the log files from exhausting host disk space.
Recovery models
ThoughtFarmer strongly recommends configuring your production database with the Simple recovery model.
Unless your IT department employs a dedicated, full-time Database Administrator (DBA) to actively manage log truncation and point-in-time recovery chains, utilizing a Full recovery model poses a high risk of unexpected storage exhaustion. Please verify that your ThoughtFarmer database properties are set to Simple to ensure stable operational overhead.
Comments
0 comments
Please sign in to leave a comment.