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 ?
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.
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.
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.