Hi all,

I am having some issues with SQL 2000 and MOM 2005:

The first doubt is, I have one database (Onepoint) with two type of Logs, *.ldf and *.mdf, the *.mdf log as 25GB and I don’t know what can I do with this.

I know that this log refers to data, but I need to reduce this size asap, I already make the shrink and truncate but the size remains almost the same.

This machine just have one hard drive with 30Gb.

Can anyone help me, any kind of help is welcome

Thanks and regards
Hugo

Do you mean mdf file is of 25 GB? If so it is not the log file it is the data file. If that doesn't reduce, then probably you got to clean up the old data from the tables and try to shrink.

And what size does the ldf file come to?

Can you post us the commands that you tried?

Cheers.

_________________________
- Vijay G
Strive for Perfection

The ldf log had 1,5Gb.
The srink tried was in the EM (SQL), right click in the database and srink
And tried the truncate: backup log database_name with truncate_only

To cleanup the log you need to do the following. Then you need to Shrink the log using The log file (.ldf) can be shrunk only to the extent of the existence of inactive transactions and not less than that.

And regarding the data file (.mdf), when you do a shrink and it doesn't come down in size, then you need to clean up the data that are older and not essentially required to exist in the DB. For this you should have had a maintenance plan planned earlier. If not you got to find out the tables on which you can run your DELETE statements and cleanup, so that there is some free space available in the data file for it to be shrunk to a lower size from 25 GB.

Hope that clarifies.
Cheers.

_________________________
- Vijay G
Strive for Perfection