SQL Server Backup or Restore using Network Share with SSMS

In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.

Partial Backups I

Mixed Backups

Taking File Backups

SQL in an Azure VM Backup

Backing up the Database Encryption Key

Managing Backup History Options in MSDB

It’s a recovery strategy, not a backup strategy

I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy.

Reducing Backup and Restore History

Two Tweaks for Faster Backups with Ola Hallengren’s Scripts

Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you’re using it for backups, there are two quick, easy changes that can dramatically reduce your nightly job runtimes.