Compacting MDF and LDF

[micang]

SQL 2000 (novice)

Hi All,

I have seen the my one databases mdf and ldf files are very large.

Is there a way of compacting\repairing these files? 9I guess somethign similar to what Access does when you compact and repair?)

Any guidance will be appreciated.

Michael

 

[AlexCuse]

Michael,

Sounds like you need to clear out the committed transactions from your t-log and shrink the file. Have a look here:

http://support.microsoft.com/kb/873235

I have never run into your problem with the .mdf but this looks like it might be helpful

http://msdn2.microsoft.com/en-us/library/ms190488.aspx

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[micang]

Thanks for the speedy reply Alex.

Michael

 

[AlexCuse]

No problem

Ignorance of certain subjects is a great part of wisdom