SIMs LDF file

[stefarr]

Hi is it ok to shrink the SIMs LDF file using SQL server management studio.

 

Its grown rather large and is now in danger of consuming the northern hemisphere

 

ta much

 

 

Steve

[Jawloms]

Capita used to, so I assume ESS now do, offer a tool which will do this. Use that.

[howartp]

https://customer.support-ess.com/csm?id=kb_article_view&sysparm_article=KB0024121&sys_kb_id=6c0fbdcc1b738dd09f2142a7b04bcb72&spa=1 once you're logged in.

 

(KB0024121 - How can you shrink the SIMS / SOLUS 3 / Discover / FMS LDF file?)

[Priya_Shah]

If you have the SQL password and can login to SQL Server Management Studio, copy and paste the script below as a New Query and Execute, which will shrink the LDF file.

Please note that in some instances '361001_log' may be 'sims_log'

 

use sims

go

alter database sims

set recovery simple;

go

dbcc shrinkfile('361001_log', 1);

go

alter database sims

set recovery full;

go

Edited January 4, 2023 by Priya_Shah

[Koldov]

(KB0024121 - How can you shrink the SIMS / SOLUS 3 / Discover / FMS LDF file?)

 

set recovery full;

go

 

Interesting as the link quotes:

 

"This will truncate the .LDF file and set the recovery model to 'Simple'."

 

Does anybody know which it is actually meant to be as as default?

 

EDIT: Also iirc isn't this meant to be part of the backup process or something?

Edited January 4, 2023 by Koldov