Somehow my database log has (ldf file) has grown to over 60GB! and the
database it is associated with is only 32MB, how can I compress this file?
it seems to be getting larger by the hour and now disk space is running
out.. thanks!Hi
Look in books online about "recovery models". You probably have the DB set
to Full Recovery and are not making transaction log backups.
Regards
Mike
"Brian Henry" wrote:
> Somehow my database log has (ldf file) has grown to over 60GB! and the
> database it is associated with is only 32MB, how can I compress this file?
> it seems to be getting larger by the hour and now disk space is running
> out.. thanks!
>
>|||How to stop the transaction log of a SQL Server database from growing
unexpectedly
http://support.microsoft.com/?kbid=873235
AMB
"Brian Henry" wrote:
> Somehow my database log has (ldf file) has grown to over 60GB! and the
> database it is associated with is only 32MB, how can I compress this file?
> it seems to be getting larger by the hour and now disk space is running
> out.. thanks!
>
>
No comments:
Post a Comment