SQL Database Optimization
Circa 3000 performs regular backup and optimization procedures to ensure that your critical SQL Server data is safe and efficient. Our schedule includes:
- Hourly
- Copy transaction log to remote server (24-hour retention)
- Clear local transaction log
- Daily
- Backup SQL Server database to disk (24-hour retention)
- Backup SQL Server database to tape (Up to 9 months retention)
- Weekly
- Optimize SQL Server database
By copying transaction logs every hour, we don't rely on daily backups alone. The problem with daily backups is that you can lose up to 24 hours of critical data in the event of a failure. Transaction logs, when frequently and properly mirrored, can rebuild critical data from the latest daily backup to within moments of the point of failure.
|
