Backup

Explore expert SQL Server backup tips, scripts, and tutorials covering full, differential, and log backups, automation, performance optimization, cloud strategies, snapshots, encryption, and best practices for DBAs managing modern SQL Server environments.

Title Author Date
Simple script to backup all SQL Server databases Greg Robidoux2026-06-25
SQL Server Default File Locations – Data, Transaction Log and Backup Nisarg Upadhyay2026-06-23
Enhancing Ola Hallengren’s SQL Server Backups for Hundreds of Databases Aaron Bertrand2026-06-22
SQL Server database backup and missing backup history scripts Tim Ford2026-06-08
Optimizing SQL Server Backups on AWS with Cost-Efficient Strategies MSSQL Tips2026-05-10
Monitor Backup Percentage Complete in SQL Server Nitansh Agarwal2026-05-03
Are Snapshots Backups? Revisiting Modern Data Protection for SQL Server MSSQL Tips2026-01-22
Types of SQL Server Backups Greg Robidoux2025-04-29
SQL Server BACKUP LOG command Greg Robidoux2025-04-29
SQL Server Partial Backups Greg Robidoux2025-04-29
Create backup using SQL Server Management Studio SSMS Greg Robidoux2025-04-29
SQL Server Backup Options and Commands Tutorial Greg Robidoux2025-04-29
Creating a backup using SQL Server Command Line (T-SQL) Greg Robidoux2025-04-29
SQL Server Recovery Models Greg Robidoux2025-04-29
SQL Server Full Recovery Model Greg Robidoux2025-04-29
SQL Server Simple Recovery Model Greg Robidoux2025-04-29
SQL Server Bulk-Logged Recovery Model Greg Robidoux2025-04-29
SQL Server Full Backups Greg Robidoux2025-04-29
SQL Server Transaction Log Backups Greg Robidoux2025-04-29
SQL Server Differential Backups Greg Robidoux2025-04-29
SQL Server Filegroup Backups Greg Robidoux2025-04-29
SQL Server File Backups Greg Robidoux2025-04-29
SQL Server Backup Commands Greg Robidoux2025-04-29
SQL Server BACKUP DATABASE command Greg Robidoux2025-04-29
How to create a SQL Server backup Greg Robidoux2025-04-29
Backup to multiple files for faster and smaller SQL Server files Greg Robidoux2025-04-20
Encrypt and safeguard your SQL Server database backups Greg Robidoux2024-05-30
How to Backup a SQL Server Database using SSMS Burt King2024-01-11
Using SQL Server Database Snapshots to Quickly Revert a Database Jared Westover2023-09-13
Automate SQL Server Backups using SQLCMD and Windows Task Scheduler Levi Masonde2023-06-27
How to Accelerate Your Database Backups MSSQL Tips2023-06-08
SQL Server Database Backup and Restore Failure Notifications Jeremy Kadlec2023-06-02
Backup SQL Database Code and SSMS Examples Joe Gavin2021-11-18
SQL Server File Snapshot Backups Mohammed Moinudheen2021-08-06
Encrypting SQL Server Backups for Legacy Systems Bernard Black2020-02-21
Backup Database Task in SQL Server Maintenance Plans Sergey Gigoyan2019-12-05
Analyze and Improve SQL Server Backup Schedule Aakash Patel2019-11-22
Automate DACPAC Creation and Setup Scripts for Database Development Haroon Ashraf2019-08-13
Manage Multiple Database Backup Formats with SSDT Haroon Ashraf2019-07-30
Creating Multiple SQL Server Database Backup Formats in SSDT – Part 1 Haroon Ashraf2019-06-13
Statement Backup Log is Not Allowed for a SQL Transaction Log Backup K. Brian Kelley2019-03-15
Auto Generate NetBackup script to backup SQL Server databases Alejandro Cobar2018-12-12
Get most recent SQL Server backup information for all databases Alejandro Cobar2018-10-22
Script for SQL Server Database Growth Since Last Backup Pablo Echeverria2018-09-14
Script to Split SQL Server Database Backups into Multiple Files Eli Leiba2018-09-12
Script to delete old SQL Server Backup Files Using Backup History Data Eli Leiba2018-08-29
Check for full SQL Server database backups before creating other backups Edwin Sarmiento2018-06-02
SQL Server Script to Determine Free Space Prior to SQL Server Backup Eli Leiba2018-05-31
CLR function to delete older backup and log files in SQL Server Greg Robidoux2018-05-29
Zip and Copy SQL Server Backup Files with PowerShell Tim Smith2018-05-21
Exploring SQL Server Table Backup Methods Jeffrey Yao2017-04-21
Backup Compression for SQL Server TDE Enabled Databases Ahmad Yaseen2016-11-16
Backup Compression Performance Enhancements for SQL Server 2016 TDE Enabled Databases Simon Liew2016-10-31
Automatic Notifications for SQL Server Databases Without Backups Angel Gomez2016-10-28
Delete old SQL Server backup files with a Stored Procedure Eli Leiba2016-10-13
Validate a SQL Server Backup can be Restored Eli Leiba2016-09-21
Invoking SQL Server Database Backups with PowerShell Adam Bertram2016-03-22
SSRS report for SQL Server Database Backup Status Scott Murray2016-02-10
Changing the default SQL Server backup folder Greg Robidoux2016-01-18
SQL Server Backups and Transaction Log Questions Sergey Gigoyan2015-12-18
SQL Server error BACKUP detected corruption in the database log Ahmad Yaseen2015-11-17
Testing SQL Server Backup Performance with Trace Flag 3042 Ben Snaidero2015-05-11
Verify SQL Server Backups Existence in the File System with PowerShell Tim Smith2015-03-17
Backing up your SQL Server to Amazon’s Cloud in Three Easy Steps John Grover2014-12-29
Automate Tracking SQL Server Backup Times with PowerShell Tim Smith2014-12-18
Checking SQL Server Database Backups When You Don’t Have Access Bernard Black2014-11-07
SQL Server 2014 Backup Encryption Daniel Farina2014-02-03
Backup and Restore with Cloud services (Windows Azure Blob Storage Service) using PowerShell Arshad Ali2013-10-11
Backup and Restore SQL Server databases with Azure cloud services and SMO Arshad Ali2013-09-23
Simple Database Backup using SQL Server Management Studio Graham Okely2013-07-29
COPY_ONLY Backups with SQL Server Greg Robidoux2013-06-06
SQL Server Backup Paths and File Management Graham Okely2013-06-05
Using passwords with SQL Server database backup files Greg Robidoux2012-11-08
Standardize SQL Server backups and maintain existing job schedules Burt King2011-12-15
Options to Improve SQL Server Backup Performance Ben Snaidero2011-11-17
Configuring Snap Backups with SMSQL for NetApps and SQL Server Scott Shaw2011-02-02
Considerations for Implementing SnapManager for SQL Server Scott Shaw2011-01-06
Function to Return Default SQL Server Backup Folder Tim Ford2010-03-19
Striping SQL Server Database Backups Thomas LaRock2010-02-12
Script to find SQL Server databases without transaction log backups Tim Ford2010-01-06
Backup and Restore SQL Server databases programmatically with SMO Arshad Ali2009-10-01
Mirrored Database Backup Feature in SQL Server Ashish Kumar Mehta2009-06-24
Copy Only Backup for SQL Server Atif Shehzad2009-06-15
How to find out how long a SQL Server backup took Thomas LaRock2009-05-08
Purging MSDB Backup and Restore History from SQL Server MSSQL Tips2009-04-10
Using the FORFILES Command to Delete SQL Server Backups Tim Ford2008-11-03
SQL Server Backup History Analysis Atif Shehzad2008-10-02
SQL Server backup and restore of the Resource database Edwin Sarmiento2008-07-21
Issues with SQL Server backup log with no_log or truncate_only Greg Robidoux2008-03-27
Stop logging all successful backups in your SQL Server error logs Greg Robidoux2008-03-18
SQL Server Database Backup Retention Periods Jeremy Kadlec2007-12-26
Large log backups with bulk operations and read only databases Chad Boyd2007-10-15
Automating Transaction Log Backups for All SQL Server Databases Greg Robidoux2007-08-28
SQL Server Backup Plan Greg Robidoux2007-07-12
Do you know if your SQL Server database backups are successful Jeremy Kadlec2007-05-23
Differential Database Backups for SQL Server Jeremy Kadlec2007-05-02
What is in your SQL Server backup files? Greg Robidoux2007-01-04
SQL Server backup and restore to network drive Greg Robidoux2006-12-07
Verifying Backups with the RESTORE VERIFYONLY Statement MSSQL Tips2006-10-20
SQL Server 2005 Backup Product Options Jeremy Kadlec2006-06-23