SEC 5.5.0 Database using a lot of space 180GB how do i shrink it?

It's the File c:\Program Files\Microsoft SQL Server\MSSQL10_50.SOPHOS\MSSQL\DATA\SOPHOSPATCH52_log.LDF

That one file is 176Gb

It's the File c:\Program Files\Microsoft SQL Server\MSSQL10_50.SOPHOS\MSSQL\DATA\SOPHOSPATCH52_log.LDF

That one file is 176Gb

Hello StephanieGelder,

you should back up the database and then either use
  sqlcmd -E -S .\SOPHOS -d SOPHOSPATCH52 -Q "DBCC SHRINKFILE (SOPHOSPATCH52_log, targetsize_in_MB)"
or             
  sqlcmd -E -S .\SOPHOS -d SOPHOSPATCH52 -Q "DBCC SHRINKDATABASE (SOPHOSPATCH52, target_percent_free)"

Christian

Thanks.

It needed another " on the end.

The shrink via MB said it wouldn't work as the logical log file located at the end of the file is in use ?

The shrink by percentage said it wouldn't work as there was no free space in the log file.  It was skipped because the file does not have enough free space to reclaim.

haha

shutdown the sophos services and then try it again?

Hi Christian found a link you sent someone else in the past that looks like it was the same....

Said had to change it to a simple database and then shrink it?

https://community.sophos.com/kb/en-us/110258

Hello StephanieGelder,

corrected the missing ", thanks.

Indeed it requires recovery model set to SIMPLE. Forgot to mention it ... Sophos's recommendation (and the settings after initial install) used to change IIRC while the Resolve Performance Issues always suggested SIMPLE. FULL is only needed for point-in-time (forward) recovery - well, dunno why someone should need it with SEC.

Christian

Just so you know, I changed the database to Simple.  Didn't appear any different, then restarted the Sophos Server and hey presto.  The file went down to under 2GB in size instead of 176GB

Hurrah!!

Hello StephanieGelder,

down to under 2GB
if you SHRINK it without a targetsize it'll go down much further ...

Christian