Backup and Restore – MidnightDBA

Backup Tuning: Part 02

This is our 2nd session on backup tuning. Today Continue reading “Backup Tuning: Part 02”

This is an extension of my backup tuning session that Continue reading “Backup Tuning – Part 1”

Yes, you can tune your SQL Server backups!

Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of Continue reading “Sean’s Famous Backup Tuning class!”

Sometimes your DB is so big you need to initialize replication with a backup and restore instead of a snapshot. Here I show you Continue reading “Replication: Initialize with Backup”

In Minion Backup, you can use regex to include/exclude DBs from a backup. This actually works with all of the modules, so it’s included Continue reading “Minion Backup: Regex vs. DBGroups”

In Minion Backup you can exclude DBs from backup based on any criteria you like. Here I’ll show you a good example with excluding Continue reading “Minion Backup: Exclude DBs by Size”

The 4th in the backup class at NTSSUG.

The 3rd in the backup class at NTSSUG.

The 6th in the backup class at NTSSUG.

The 5th in the backup class at NTSSUG.

The 2nd in the backup class at NTSSUG.

This is the first of a series to teach you how to think like and become an enterprise DBA. The skills and the mindset Continue reading “NCC-1701-DBA: 1 of 6”

Learn how to do a backup across the LAN.

This one covers restore with move syntax to restore DBs while moving the files to a different location.

This is a tutorial not only on how to turn your backup commands into SPs, but also the basics of stored procedures are discussed.

In this video I discuss the init option for the backup command. You’ll come away knowing how to use it and what it’s for.

This one covers restore with move syntax to restore DBs while moving the files to a different location.

Database maintenance isn’t a single event; it’s a lifecycle. Aside from the maintenance event itself, there’s also reporting, error management, specialized configs, HA/DR and more. Continue reading “The Enterprise Maintenance Lifecycle: Problems & Solutions”

Here I talk about how you can use the file extensions to your advantage, but also have a little fun with it too.

Here I show you how to do simple backups in SQL.

Here I show you how to setup backups to Azure blobs. This is an end to end video and I show you from both the Continue reading “Minion Backup: Azure Backups”