Email from Siemens to query the SQL backups at Coventry. The following error was being received regularly.
Error: The disk C: on computer BIMS is running out of disk space. The values that exceeded the threshold are 0% free space and 258 free Mbytes.
Question from Siemens: Do sites need to keep all the SQL backups on locally hosted server for BIMS?
Solution (provided by Savant):
Backups don’t need to be retained for long as the number of transactions (deliveries, issues, etc) is constantly changing so to rollback any further than 24 hours would result in potentially losing a lot of data.
Normally, I would recommend keeping full backups for 3 days, this should be settable in the maintenance plan in SQL server. Please also check that they are backing up the transaction log, if not, this can get much larger than the database itself.
The transaction log should be backed up at least once a day (overnight after the full backup) but can be done more often to reduce the amount of data that could be lost and also to keep the transaction log small.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article