Are you following DBA best practices?

Performing a daily full backup of all system and user databases is crucial to keeping your data safe. However, backups this frequent can consume valuable time and disk space.

Reduce the time and disk space needed for daily full backups with SQL Backup Pro. Its high-performance compression, network resilience and other powerful features mean faster, smaller, more robust SQL Server backups.

SQL Backup logo
  • Compress your backups by up to 95% to save time and storage space
  • Strengthen backup activities across networks using network resilience to minimize the disruptions to your backups caused by flaky networks
  • Protect your data with 256-bit AES encryption
  • Monitor your backup activities in a single, intuitive interface


Brad McGehee's Backup Best Practices

SQL Server DBA Best Practices

Brad McGehee, expert DBA and Director of DBA Education at Red Gate, has selected his top five backup best practices for SQL Server DBAs. Read some of his hard-learned advice and start creating the best backups of your career!

"Whenever it is possible, perform a daily full backup of all system and user databases."
   

"For all production databases, perform regular transaction log backups, at least once an hour."
   

"If backups take longer than your backup window, or if backup files are taking up too much space, consider a third-party backup program."
   

"Encrypt all SQL Server backups with a third-party backup tool."
   

"Periodically test backups to ensure that they are good and can be restored."