Dear All

our log file in SQL SERVER is 136 Go (by Accident) and our hard disk is nearly full (only 5 Mo are free)

please provide best solution for reduce space of log file to 5 Go for exemple or advice

Best Regards :confused:

You mean, you have a 136GB transaction logs in SQL Server?

The right way of handling this is to configure a online or transaction log backup. This would trunacte the file.

Alternatively (but not recommended by MS):

a) Shutdown the database
b) rename the log file
c) Start the database

On startup SQL Server will create a new log file. Is everything is working and no data got lost in the process, then you can delete the old logfile.

You find lots of hints for this on the internet too. Search for "truncate SQL server log" or something like this.

Rergards

Markus

Hello,

You can Try "Shrink Database" Option in SQL Server.

BR,
Sushil Kumar Mudaliar

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