undo checkout increase the db log file size

yamao · Post by **yamao** » Thu Oct 25, 2007 3:20 pm

When we try to do the undo checkout operation, it takes long time and database log file increase by at least 1GB,

Any ideas?

Thanks in advance!

lbauer · Post by **lbauer** » Thu Oct 25, 2007 8:14 pm

What version of Vault are you using?

If you had a checkout of many files, undoing the checkout causes many transactions, and that causes the transaction log to grow.

You can keep the transaction log smaller by using the Simple Recovery model for the database (this means the log is not used to recover the database -- you would restore the last good backup). Also check the growth properties of the database -- if it is set to grow by a percentage every time SQL Server needs more space, this could cause it to grow too much. These settings are in the database options for sgvault database in SQL Server.