A collection of articles covering differential backup, SQL database backup and SQL Server copy only backup
Backup management
- How to create Copy-Only backups in SQL Server
- Create daily database backups with unique names in SQL Server
- How to back up a database without the index data
- How to create and manage SQL backup policies
- How to create multiple SQL Server backup mirrors
- How to create SQL Server database split backup files
- How to schedule a SQL Server backup
- How to set up email notifications for backup jobs in SQL Server
- Manage and monitor SQL Server backups from a central location
- Manage multiple database backups across different SQL Server instances
- How to create and manage database backup chains in SQL Server
- How to backup multiple SQL Server databases automatically
- Multi server PowerShell script to backup SQL Server databases automatically
- How to restore specific table(s) from a SQL Server database backup
- How to get a backup SQL database history
Encryption
Log shipping
Restore
- How to automate DBCC CHECKDB after a database restore
- How to restore only a specific filegroup – A piecemeal restore
- How to schedule a database backup restore in SQL Server
SQL Server maintenance
- How to delete old database backup files automatically in SQL Server
- How to perform a SQL backup and restore history cleanup
- SQL Server database shrink – How and when to schedule and perform shrinking of database files
- Why, when and how to rebuild and reorganize SQL Server indexes
