Single User Mode Can Be Misleading

This is something that might seem obvious to DBAs, but I was speaking with a developer this morning and realized there can be some confusion about what exactly single user mode means. A database can be in multi-user mode, where multiple connections can be made to it, or single user mode, where only one person […]

Share

Sometimes It’s The Little Things That Get You

I recently performed an in-place upgrade of a SQL Server from SQL 2008 R2 to SQL 2012. All seemed to work well, until I tried taking a database backup. That failed. This particular SQL Server uses LiteSpeed for backups and the following error was being returned when it ran: Msg 17750, Level 16, State 0, […]

Share

Determining If A Full Backup Is Needed For A Log Or Differential Backup

What annoys you? For me, a few things I find annoying are people talking on cell phones in restaurants, people chewing with their mouth open, and getting calls from telemarketers. SQL jobs failing also annoy me. OK, maybe not as much as Chatty Cathy yakking with her friend on the phone during dinner, but it’s […]

Share

TRY / CATCH Can Catch More Than Just Errors

I’ve been experiencing an intermittent problem with my automated backup testing routine for some time now. I would occasionally get a failure during a restore, but when I manually ran the exact same restore command, the restore worked without issue. Because my testing routine selects a random sample of backups to test, I was not […]

Share