Browsed by
Category: MSSQL

Corrupt Microsoft SQL Database Log in AlwaysOn High Availability Group (AAG)

Corrupt Microsoft SQL Database Log in AlwaysOn High Availability Group (AAG)

We recently ran into an issue with one of our environments where the Microsoft SQL Server experienced corruption in the database log. This issue is usually discovered when you attempt to create a new backup and it fails with the message “BACKUP detected corruption in the database log” Resolving this issue is normally fairly easy (set the database from a Full Recovery Model to simple and then back again) but it gets a bit more complex when you database is…

Read More Read More

FreeTDS and Microsoft SQL Server Windows Authentication – Part 1

FreeTDS and Microsoft SQL Server Windows Authentication – Part 1

I’ve been trying to get the Zenoss SQL Transaction Zenpack working so that we can use Zenoss to run SQL queries for specific monitoring purposes and ran into a few things that might be worth sharing. Using tsql for troubleshooting Zenoss, among many other tools uses pymssql to connect to your SQL Servers; and pymssql uses FreeTDS behind the scenes. If you can’t get pymssql to work them you can go a layer deeper to see if you can find…

Read More Read More