cancel
Showing results for 
Search instead for 
Did you mean: 

Foundstone database transaction log

H,

I have upgraded my fs850 to mvm3100 with VM 7.0, but now the transcation logfile size is nearly 90 gb. how i can resuce the file size ?

What is the recommended procedure to improve the performance ?

Thanks,

Rajeev

0 Kudos
3 Replies
josepht
Level 7

Re: Foundstone database transaction log

Hi Rajeev,

To reduce the log file size, you can set the Recovery Model of Faultline db to Simple and perform a backup.

You can also use the Shrink > Files under Tasks from the management studio.

Thanks

Joseph

0 Kudos

Re: Foundstone database transaction log

Thanks Joseph!!

Just the shrink will solve the issue ? or set the recovery to simple ? Is backup required  after setting to simple recovery?

please confirm on this.

0 Kudos
josepht
Level 7

Re: Foundstone database transaction log

Just a shrink maynot solve the issue. When you are at the shrink file dialog, select log and you would see the size and the free space available to shrink. When you have a Full recovery model, too much data will be logged. Once you set your recovery model to Simple you will not notice the huge growth of log file. Backup is not mandatory. Just setting the recovery model to Simple followed by a shrik should work for you.

Thanks

Joseph

0 Kudos