Huge Log File

sdoc · Post by **sdoc** » Mon May 21, 2007 11:30 am

Our sg_vault.LDF file has grown to almost 90+GB. Is this log file directly associated with the access log of the projects in sourcesafe? or is this just a transaction log of SQL Sever? is there any way to purge this regularly?

Thru SQL Server Management Studio i noticed that the log file has been set to have "unrestricted growth"(under Database Properties>Files).If i set this to a certain value ex. 1GB ,will that affect the range of "History" i see of the projects within vault? ex. will i lose the history in vault? are the two tied?

lbauer · Post by **lbauer** » Mon May 21, 2007 2:59 pm

If SQL Server is set to use the Full recovery model, the log file can grow large between backups, especially if you have many transactions.

You can shrink the transaction log, or better yet, backup the database then truncate the log file. This is the database log file, so it is needed for the database to work properly. It is not a SQL Server log file.

You can set your recovery model to Simple if you want to rely on the last full backup in case of disaster recovery, rather than the last backup and the transaction log.

For further information, see this Microsoft article:

http://msdn2.microsoft.com/en-us/library/ms191164.aspx

Regarding the database growth. The sgvault database does need to grow, but you can set it to grow by a certain number of megabytes, rather than by a percentage. This should slow down the growth.