A Script for Migrating SQL Data (and Log) Files
Suppose that you’ve been asked to migrate 166 databases’ .mdf files from one drive to another. How would you do that? I’d generate a list based on the .mdf files (the databases are all named the same thing as the .mdf. If this wasn’t the...A one-time use script.
This isn’t the entire thing, it’s bits and pieces, but it’s enough for you to bend, fold, spindle, and mutilate for your own purposes. I was given 70,000+ tab delimited lines that were output dumped from a program and asked to find out what version...Nagios Plugin – SQL Job Status
I checked out Nagios Exchange, and didn’t see anything that checked the status of a job and used Windows/AD credentials/trusted connection. So I wrote this. It’s intended to run as an NRPE script, and doesn’t require anything that doesn’t come...Subscribe
