This is our 2nd session on backup tuning. Today Continue reading “Backup Tuning: Part 02”
Tag: Backup/Restore
Backup Tuning – Part 1
This is an extension of my backup tuning session that Continue reading “Backup Tuning – Part 1”
Minion Backup Intro Webinar: 6/1/2016
This is an intro to Minion Backup that shows you Continue reading “Minion Backup Intro Webinar: 6/1/2016”
Sean’s Famous Backup Tuning class!
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!”
Replication: Initialize with Backup
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”
Minion Backup: Regex vs. DBGroups
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”
Minion Backup: Exclude DBs by Size
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”
Best Backup Class Evar: 4 of 6
The 4th in the backup class at NTSSUG.
Best Backup Class Evar: 2 of 6
The 2nd in the backup class at NTSSUG.
Best Backup Class Evar: 3 of 6
The 3rd in the backup class at NTSSUG.
Best Backup Class Evar: 5 of 6
The 5th in the backup class at NTSSUG.
Best Backup Class Evar: 6 of 6
The 6th in the backup class at NTSSUG.
NCC-1701-DBA: 1 of 6
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”
Minion Backup: BackupRestoreDB
We’ve got some great new functionality in 1.3 for restoring DBs. Here I tell you what you need to know.
Remote Backups
Learn how to do a backup across the LAN.
RESTORE with move
This one covers restore with move syntax to restore DBs while moving the files to a different location.
Simple Backup Procedures
This is a tutorial not only on how to turn your backup commands into SPs, but also the basics of stored procedures are discussed.
Backup with Init
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.
Trace Flag 1807
This one covers restore with move syntax to restore DBs while moving the files to a different location.
Inline Tokens
This is a great new feature of MB 1.3. It allows you to have dynamic paths and filenames for your backups. Here, I Continue reading “Inline Tokens”
Who is MinionWare?
Who is MinionWare Software? Here we explain the core of our product line and give you a short demo of a couple cool features.
The Enterprise Maintenance Lifecycle: Problems & Solutions
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”
Backup File Extensions
Here I talk about how you can use the file extensions to your advantage, but also have a little fun with it too.
Simple Backup
Here I show you how to do simple backups in SQL.
Change Excel Delimiter
Description
Minion Backup: Dynamic Parts
Minion Backup 1.3 has a fabulous new feature: Dynamic Parts. This allows you to have unprecedented control over your paths and filenames.
Minion Backup: Backup ResourceDB
The ResourceDB in SQL Server doesn’t backup like regular DBs. Come see how to do this in Minion Backup 1.2 and below.
Minion Backup: Shrinking Logs
When logs get too large because of large transactions or missed backups it can cause issues in your environment. And the DBA usually has to Continue reading “Minion Backup: Shrinking Logs”
Minion Backup: Striping Backup Files
Striping backups is an important step in tuning your backups so they run nice and fast. MB makes it so easy to have specialized configurations Continue reading “Minion Backup: Striping Backup Files”
Minion Backup: Include / Exclude Databases
MB has a few ways to include and exclude databases from the backup process. Here I walk you through the nuances of this feature. Some Continue reading “Minion Backup: Include / Exclude Databases”
Minion Backup: Status Monitor
We consider this one of our flagship features. The status of the current backup and of the entire job is updated in the log. You Continue reading “Minion Backup: Status Monitor”
Minion Backup: Server Labels
Server labels are one of our great high availability features. This feature allows you to organize Availability Group backups as well as mirroring, log shipping, Continue reading “Minion Backup: Server Labels”
Minion Backup: Replacing Diff Actions
Some DBs are too small to need a differential backup. MB makes it really easy to supply different actions in these situations. You can have Continue reading “Minion Backup: Replacing Diff Actions”
Minion Backup: Path Basics
One of the coolest aspects of MB is how it handles your backup paths. There are some really cool options for configuration and it even Continue reading “Minion Backup: Path Basics”
Minion Backup: File Actions
This is an important feature. MB allows you to copy or move your backup files after you take the backup. There are some pretty cool Continue reading “Minion Backup: File Actions”
Minion Backup: Mirroring Backups
Mirroring backups is not only easy it’s very flexible. Here I’ll show you the ins and outs of setting up and managing mirrored backups.
Download Minion Continue reading “Minion Backup: Mirroring Backups”
Minion Backup: Tuning Threshold Basics
One of Minion Backup’s most incredible features is its dynamic tuning. Here I talk about threshold basics and how to configure the settings to do Continue reading “Minion Backup: Tuning Threshold Basics”
Minion Backup: Encrypted Backups
SQL Server 2014 and above has native backup encryption and this is fully supported by Minion Backup. Here I’ll show you how to setup and Continue reading “Minion Backup: Encrypted Backups”
Minion Backup: Azure Backups
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”
Minion Backup: Advanced Tuning Thresholds
Here I show you how to configure MB backup thresholds using the advanced options. If you’re going to get it right you need to watch Continue reading “Minion Backup: Advanced Tuning Thresholds”
Minion Backup: Certificate Backups
Minion Backup will automatically backup your server-level and database-level certificates. Here I’ll show you what you need to know to be successful with this feature.
Download Continue reading “Minion Backup: Certificate Backups”