Skip to Content
1

SBO COMMON LDF FILE TO COMPRESS

Nov 15, 2016 at 12:29 PM

42

avatar image

Dear Experts,

Due to Non availability of free space in c drive thinking to compress sbo common ldf file.

Is it ok to compress sbo common ldf file

Regards,

Karthik b

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Johan Hakkesteegt Nov 15, 2016 at 01:19 PM
0

Hi Karthik b,

You can compress it, but that will slow the system down. I would not recommend it. I would advise to include the SBO-Common database in a normal maintenance job, and shrink it on a regular basis. Also, it would be much more effective to do something about the size of the company database.

The SBO Common ldf file should not be much more than about 10% of the size of your company database. If it is a lot larger than that, you should check that the recovery model has been set to Simple. If it is set to something else, please change it to Simple, and perform a shrink operation.

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded