Normally, with a SQL database, the transaction log file AyaNova_log.LDF file can be up to 20% larger than the actual database file AyaNova.mdf
The log file records all of the transactions in the database.
If you check your log file, and it is much larger than 20% of the database (I’ve seen log files that are 20GB when the database is only 100MB), issues can arise.
-The log file could continue to grow and eventually crash your computer when it runs out of hard drive space
-Hard drive space is being wasted unnecessarily
-Your backup space on backup devices is being wasted unnecessarily
-The time to backup takes a very long time
Here’s an informative page about this http://www.nigelrivett.net/TransactionLogFileGrows_1.html
Basically, ensure that the database is set to Simple Recovery mode and than shrink the log file.
Refer also to the Microsoft topics:
How to stop the transaction log of a SQL Server database from growing unexpectedly http://support.microsoft.com/kb/873235/en-us
A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server http://support.microsoft.com/kb/317375/en-us
Reasons for not wanting to shrink the log would be can be found on this page http://www.karaszi.com/sqlserver/info_dont_shrink.asp