August 2010 Entries

VBScript to Check Database Log Size and Email Alert if it Exceeds the Threshold
Today I decided to share a script I wrote that checks for a specific database log size and if it exceeds a certain predefined limit sends an alert email to a user of choice. Of course, there is a possibility to add more databases to check and/or more database files. Thought the script might come up handy for a DBA trying to avoid a situation with a rapidly expanding log file thus bringing down its database by scheduling it to run in short intervals, here is the code: 1: Dim Connection 2: Dim ConnString ......

Posted On Friday, August 27, 2010 11:44 AM | Comments (2)

Recovering a Failed SQL Server Database From Running out of Disk Space
Just had a SQL Server 2005 database completely becoming unavailable after the drive on which its files were residing on completely ran out of space (thanks god in development). Freeing some space turned out to be a more or less strait-forward step. Now the recovery stage. Interestingly, out of a dozen databases (all in SQL 2000 compatibility mode) only one became affected. When I started to figure out what is wrong I checked the SQL Server log first and could see that another database’s log file ......

Posted On Wednesday, August 25, 2010 3:07 PM | Comments (1)

Utimaco’s SafeGuard Would Not Let Boot into the OS
Recently I was given a new Win XP SP3 laptop with Utimaco’s SafeGuard Enterprise 5.35 installed. Just to briefly mention here that this is a quite popular disk encryption software. I let the it encrypt the laptop’s hard-drives and I did not have any problems restarting it. The next days the machine started fine too, and then it was Sunday when I was home having some spare time and wanted to complete some work… I reached out to my laptop, pressed the power button, and to my astonishment the computer ......

Posted On Saturday, August 21, 2010 5:49 PM | Comments (5)