SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Nebraska SQL from @DBA_ANDY

I’m a forty-something Microsoft SQL Server DBA of 15+ years, a devoted husband, and a father of three young boys. I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a remote DBA with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

Archives: December 2015

The transaction log for database 'ABC' is full due to 'ACTIVE_BACKUP_OR_RESTORE'

I have recently had a client with a problem each morning where they were having processes fail with this message in their SQL Server Error Log:
Date 12/01/2015 5:58:48 AM
Log SQL Server (Current - 12/01/2015 1:00:00 PM)
Source spid118
Message Error: 9002, Severity: 17, State: 3.
Date 12/01/2015…

Read more

5 comments, 9,397 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 December 2015

What Permissions Does This Login Have?

I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer.  Grant the login the same permissions as Domain\Mary.
On the face of it, this seems relatively straightforward, right?  It is the kind of request that we all get from time to time, whether as an…

Read more

4 comments, 1,833 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 December 2015

T-SQL Tuesday #73 - Not Running CHECKDB is Naughty!

This month T-SQL Tuesday is hosted by Bradley Balls (blog/@SQLBalls) and his topic of choice is “Naughty or Nice.”

(If you don’t know about T-SQL Tuesday check out the information here – each month there is a new topic and it is a great…

Read more

0 comments, 2,823 reads

Posted in Nebraska SQL from @DBA_ANDY on 8 December 2015

What Do You Mean There is No Current Database Backup?!?

Yet another late night/early morning tale...

The LOG backups for multiple databases on a server failed overnight (not all databases, but many of them), and looking in the output file from the LiteSpeed Maintenance plan (the client's tool of choice) I found entries like this:

Database Database01: Transaction Log Backup...

Read more

0 comments, 831 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 December 2015