Service Desk Practitioners Forum
cancel

data crunch

SOLVED
Go to solution
Highlighted
kinglee
Contributor.

data crunch

I have an OVSD 4.5 setup which has MSSQL 2k5. I can see that the .ldf file is alarmingly big(32 GB). what can I do to remove this? what should be done on a regular basis to keep it low?

Thnx
kinglee
1 REPLY
The Pike
Acclaimed Contributor.
Solution

Re: data crunch

Any qualified DBA would know what to do.

How to stop the transaction log of a SQL Server database from growing unexpectedly
-- http://support.microsoft.com/?kbid=873235

Do not forget to assign points for the answer.
Here's how:
http://forums13.itrc.hp.com/service/forums/helptips.do?#33

The Pike