Enourmous lansweeper31_log.LDF file

[wavin]

Hello ,

I have a problem on my server where SQL is installed : the C:\ disk is full.

I discovered that I have on my folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data one file called

lansweeper31_log.LDF

that is 51GB big ( 51.090.368KB )!!!

What is this file ??? Can I delete/move it ??

Thanks for your support

[wavin]

Incredibile !!!

After the shrink of the database , the lansweeper31_log.LDF file is now 503KB only !!! From 50GB to 503KB , I do not belive that !

Thanks for your help :-))

[Hemoco]

Please see attached PDF file on how to shrink.

After changing to simple mode you won't have this problem again.

[wavin]

Hello ,

we are running Lansweeper on MS SQL Server 2005 and yes we do have access to the console.

I really do not understand the dimension of lansweeper31_log.LDF file. We only have 250 client on our domain , I do not think that is a big number !

Thank you for any help !

[Hemoco]

Which version of SQL server are you running?
Do you have access to the SQL management console?

[wavin]

Hello ,

could you please be more clear ? I do not understand your solution.
What does "The log file is trucated in sql every time you make a backup" mean ?
How can I change the database recovery model to "simple" ?
How can I "Shirnk" the database/log file in sqlserver ?

Thank you

[Hemoco]

The log file is trucated in sql every time you make a backup.

The easiest solution is to change the database recovery model to "simple"
After this shrink the database/log file in sqlserver.