Is there any way to reduce the size of the SQL database log file?
Also, can I limit the amount of ‘backup history’ to only weekly rather than daily?
I have used the 'Scheduled SQL Jobs Module - Iowa (Mitchel Sellers)' to run the following:
Shrink Database Job Type
Truncate EventLog Job Type
Truncate SiteLog Job Type
The problem is that my SQL database log is so large.
xxxx 10.63 Mb DATA
xxxx_log 194.56 Mb LOG
See details below:
The web and SQL is hosted by a 3rd-party company
Database Server Information:
Microsoft SQL Server 2005 - 9.00.4035.00
Database Backup History:
Displays the last 20 database backups for this DotNetNuke installation. This list may not be complete if you regularly clean your database backup history tables.
Backup Name Started Finished Size (Kb) Backup Type
xxxx_backup_20091216010012 16/12/2009 16/12/2009 11,774,464.00 Database
xxxx_backup_20091215010010 15/12/2009 15/12/2009 14,919,168.00 Database
xxxx_backup_20091214010011 14/12/2009 14/12/2009 14,918,144.00 Database
xxxx_backup_20091213010012 13/12/2009 13/12/2009 14,917,120.00 Database
xxxx_backup_20091212010013 12/12/2009 12/12/2009 14,916,096.00 Database
xxxx_backup_20091211010007 11/12/2009 11/12/2009 14,915,072.00 Database
xxxx_backup_20091210010007 10/12/2009 10/12/2009 14,914,048.00 Database
xxxx_backup_20091209010007 9/12/2009 9/12/2009 14,913,024.00 Database
xxxx_backup_20091208010007 8/12/2009 8/12/2009 14,912,000.00 Database
xxxx_backup_20091207010006 7/12/2009 7/12/2009 13,862,400.00 Database
xxxx_backup_20091206010008 6/12/2009 6/12/2009 13,861,376.00 Database
xxxx_backup_20091205010011 5/12/2009 5/12/2009 13,860,352.00 Database
xxxx_backup_20091204010006 4/12/2009 4/12/2009 13,859,328.00 Database
xxxx_backup_20091203010006 3/12/2009 3/12/2009 13,858,304.00 Database
xxxx_backup_20091202010006 2/12/2009 2/12/2009 13,857,280.00 Database
xxxx_backup_20091201010007 1/12/2009 1/12/2009 13,856,256.00 Database
xxxx_backup_20091130010008 30/11/2009 30/11/2009 13,854,208.00 Database
xxxx_backup_20091129010007 29/11/2009 29/11/2009 13,853,184.00 Database
xxxx_backup_20091128010008 28/11/2009 28/11/2009 13,851,136.00 Database
xxxx_backup_20091127010006 27/11/2009 27/11/2009 13,850,112
Database Files:
Displays a list of data and log files for this DotNetNuke installation.
xxxx 10.63 Mb DATA C:\...\SQL Data\xxxx.mdf
xxxx_log 194.56 Mb LOG C:\...\SQL Logs\xxxx_log.LDF
Any help would be greatly appreciated.
Many thanks.