Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....  Read more...

I wonder if you’ve had the situation that I had before where you have to attach a database with one...  Read more...

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

You have been doing a fantastic job of late.  You have all of your databases being backed up on a...  Read more...

We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...  Read more...

This is a quick rewrite of the script I just posted a few days ago.  The script had a few...  Read more...

Odd Man Out SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood. Let’s...  Read more...

5 Second Rule Doesn’t Apply to Dropped Databases or Does It? 5 Second Rule Doesn't Apply to Dropped Databases or Does...  Read more...

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option. It’s trivial to switch the database online. Not...  Read more...

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...  Read more...

Before restoring backup, we always verify the backup file first, and run the 3 command below: 1. RESTORE HEADERONLY     Returns a result...  Read more...

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....  Read more...

In response to my last post, I got a very interesting comment from Philip: “I would love to see a way...  Read more...

So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information...  Read more...

Remember kids... Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...  Read more...

I want to say a few things about database backups that you need to know. Wait a minute, haven’t you written...  Read more...