Got a call from the company I used to work for and they needed some help with restoring a backup. No problem. Sounded easy. Turns out, it wasn’t quite so simple. In fact, I had to put on my robot hat again. The company was trying to restore a database to a point in time. […]
I had to play detective a bit this week. I get a weekly report that gives me a list of databases that have more than 50 VLFs in their transaction log files. I posted the code that generates it here. My transaction logs are in pretty good shape now and I only occasionally get a […]
Writing scripts is often an iterative process. I’ll create something that works and use it for a couple months, then run into a case I didn’t think of or that behaves a little differently, and I’ll have to modify the script to handle it. Sometime later, the same thing will happen and I’ll make more […]