SQL Server Backup Tips
Administration
- Check for full SQL Server database backups before creating other backups
- CLR function to delete older backup and log files in SQL Server
- Creating Multiple SQL Server Database Backup Formats in SSDT - Part 1
- Do you know if your SQL Server database backups are successful
- Large log backups with bulk operations and read only databases
- Manage Multiple Database Backup Formats in SQL Server Data Tools (SSDT) - Part 2
- Script to show how much a SQL Server database has changed since last full backup
- SQL Server backup and restore of the Resource database
- SQL Server backup and restore to network drive
- SQL Server Backup Plan
- Using the FORFILES Command to Delete SQL Server Backups
- What is in your SQL Server backup files?
Cloud
- Backing up your SQL Server to Amazon's Cloud in Three Easy Steps
- Backup and Restore SQL Server databases with Azure cloud services and SMO
- Backup and Restore with Cloud services (Windows Azure Blob Storage Service) using PowerShell
Configuration
- Changing the default SQL Server backup folder
- Function to Return Default SQL Server Backup Folder
- Purging MSDB Backup and Restore History from SQL Server
- SQL Server Database Backup Retention Periods
- Stop logging all successful backups in your SQL Server error logs
Copy Only
Corruption
Database
Delete
- Delete old SQL Server backup files with a Stored Procedure
- Script to delete old SQL Server Backup Files Using MSDB Backup History Data
Encryption
- Encrypting SQL Server Backups for Legacy Systems
- Encrypting SQL Server backups with open source tools
- SQL Server 2014 Backup Encryption
File System
Maintenance Plans
Mirrored Backups
Monitoring
- Automate Tracking SQL Server Backup Times with PowerShell
- How to find out how long a SQL Server backup took
- How to monitor backup and restore progress in SQL Server
- Script to find SQL Server databases without transaction log backups
- Script to obtain most recent SQL Server backup information for all databases
- Script to retrieve SQL Server database backup history and no backups
- SQL Server Backup History Analysis
- SQL Server Database Backup and Restore Failure Notifications
- Verifying Backups with the RESTORE VERIFYONLY Statement
Notifications
Performance
- Backup Compression Performance Enhancements for SQL Server 2016 TDE Enabled Databases
- Backup to multiple files for faster and smaller SQL Server files
- Options to Improve SQL Server Backup Performance
- Striping SQL Server Database Backups
- Testing SQL Server Backup Performance with Trace Flag 3042
PowerShell
- Invoking SQL Server Database Backups with PowerShell
- Zip and Copy SQL Server Backup Files with PowerShell
Reporting
- Checking SQL Server Database Backups When You Don't Have Access
- SSRS report for SQL Server Database Backup Status
- Verify SQL Server Backups Existence in the File System with PowerShell
Scheduling
- Analyze and Improve SQL Server Backup Schedule
- Standardize SQL Server backups and maintain existing job schedules
Scripts
- Auto Generate NetBackup script to backup SQL Server databases
- Automating Transaction Log Backups for All SQL Server Databases
- Backup and Restore SQL Server databases programmatically with SMO
- Differential Database Backups for SQL Server
- How to Identify and Backup the Latest SQL Server Database in a Series
- Simple script to backup all SQL Server databases
- SQL Server Script to Automatically Split Database Backups into Multiple Backup Files
- SQL Server Script to Determine Free Space Prior to SQL Server Backup
Security
- Encrypt and safeguard your SQL Server database backups
- Using passwords with SQL Server database backup files
SnapManager
- Comparing SQL Server Native Backup Times to SnapManager Backups
- Configuring Snap Backups with SMSQL for NetApps and SQL Server
- Considerations for Implementing SnapManager for SQL Server
Table
Tools
- How to create a simple database backup using SQL Server Management Studio (SSMS)
- SQL Server 2005 Backup Product Options
Transaction Logs
Transparent Data Encryption
Troubleshooting