Speed up SQL Server backups with one word
Fast backups mean fast restores. SQL Server native backup compression makes that happen! Read on for the pros, the cons, and the how-tos.
Minion Backup
These five SQL tools are essential for 2020
The tech world is just beginning to adapt to the “new normal”, and we’re all adjusting. Your best toolkit for 2020 will include these five downloads, which you should get and install *today*.
Minion Maintenance: Just make it go!
Minion Maintenance has some seriously thorough documentation, but some weeks you don’t have time to read the darn manual. When it comes to backups, CheckDB operations, and index maintenance, you just want it to WORK. So here’s the “just make it go!” guide to Minion Maintenance! Don’t have Minion Maintenance? Download! Download the latest Minion …
Ten minute SQL Server backup and maintenance
We’re going to set up backup, DBCC CheckDB, and index maintenance for 5 servers in 10 minutes. Note that doing the same thing for 50 servers would take the same amount of time! Why do backups and CheckDB and index maintenance? Backups make a copy of the data or log records. This is vital for …
Minion Backup: Restore to another server
Minion Backup makes your SQL Server backups effortless, of course. And even better, it makes your restores effortless! Today we’ll look at configuring a common, repeatable scenario: take the latest backup of MyDB from ProdServer1 and restore it to DevServer1.
Code that writes code
Code that writes code is one of the best productivity tips I can give you. And no, I’m not talking about ORMs. I’m specifically talking about YOU writing a query, which writes one or more queries.
We just upgraded the Minion Maintenance suite!
Welcome to the next version of Minion Maintenance! Now you have a single installer for all three modules, plus new features and fixes for the entire backup and maintenance suite!
Your Service Level Agreement is a Disaster
As a DBA, you’re in charge of getting systems up and running quickly in the event of an emergency. This is all right and proper, right up until you start defining SLAs. Let’s see what went wrong.
Build Dynamic Backup Locations with Minion Backup
When you back up your database with a third-party party backup utility, you’re almost always stuck with their hard coded path structure and file names. But Minion Backup – our free SQL Server backup tool – gives you fully dynamic paths and file names. You can even programmatically change them based on any criteria. We call …
Build Dynamic Backup Locations with Minion Backup Read More »
Distinguish backup file names or pay the price!
So far, no one has found exercise to be beneficial to servers. Purposeless repetitive motion may be good for human muscles, but your SQL Server instance experiences no gain for the pain. Here’s a good example: taking useless backups. Let me explain…