As your product works with the SQL Server database system, the transaction log file can grow very large. The larger it gets, the more sluggish the performance of your product becomes.

Shrink the transaction log file.  

• Start the SQL Server Management Studio by clicking Start, All Programs, SQL Server, SQL Server Management Studio.
• In the left pane, expand the Databases item, and right-click wkennel and choose Properties.
• Click Options.
• Change the Recovery model option to Simple, if it isn't set to that already.
• Click OK
• Right-click the database again, and choose Tasks -> Backup...
• If there is a backup filename listed under Back up to, click on it once and click Remove to remove it. Do this for all file names listed.
• Select Disk in the Back up to section toward the bottom and click the Add button
• Give the backup file a name, and include the full path to it, and .bak as the extension. For example, C:\KCBackup.bak
• Click OK and the database will be backed up.
• Right-click the database again, and choose Tasks -> Shrink files
• Change file type to Log
• Click OK.
• Now reset the recovery model back to Full: In the left pane, expand the Databases item, and right-click wkennel and choose Properties.
• Click Options.
• Change the Recovery model option to Full.
• Click OK

The preceeding procedures will shrink the log file and return the original speed back to your product. For good measure, reboot the SQL Server computer