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 […]
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, […]
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 […]
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 […]
I’ve been playing around some more with SQL 2012 and I discovered another nice little improvement. This isn’t anything huge, but rather a nice little touch that makes my life as a DBA a little bit easier. If you have your SQL Agent jobs configured to send you email when they fail (or succeed or […]