Database Maintenance For Non-DBAs

I got an email the other day from a friend who needed some SQL help. He had a SQL Server with a database whose transaction log had grown and was filling the entire disk drive. This is a common problem that system administrators face in shops that do not have a DBA on staff. The […]

Deleted Logical Data File Reappears In LiteSpeed Backup After 2005 to 2008 R2 Conversion *UPDATED*

I recently migrated a database from a SQL 2005 SP3 server to a 2008 R2 SP1 server. In the 2005 SQL Server, the database consisted of three logical and physical files. I moved it to the 2008 R2 server by taking a native SQL backup and restoring it on the new server using the WITH […]

Backup Verification, Statistical Sampling, And You

I’m always eager to expand my knowledge about SQL Server and I have a list of about 10 SQL-related blogs that I check on a daily basis. I’ve picked up lots of good info from them and occasionally, I’ll come across something that sticks in my head because I think it’s just all kinds of […]

It’s 12 AM. Do You Know What Your Backups Are Doing?

After watching Brent Ozar’s webinar on backups and virtual machines, I was inspired to take a deeper look at our company’s overall backup plans.  I had already gone through the code that was actually doing the backup, found some crazy stuff, and fixed it, but this time through I wanted to take a closer look […]