ALTER DATABASE AtlassianJira SET RECOVERY SIMPLE;
GO
CHECKPOINT;
GO
DBCC SHRINKFILE ('AtlassianJira_log', 250);
GO
ALTER DATABASE AtlassianJira SET RECOVERY FULL;
GO
All essays
Reduce Jira SQL Server Log Database Size
ALTER DATABASE AtlassianJira SET RECOVERY SIMPLE; GO CHECKPOINT; GO DBCC SHRINKFILE ('AtlassianJira_log', 250); GO ALTER DATABASE AtlassianJira SET RECOVERY FULL; GO
Keep reading
Related essays you might like
January 28, 2026
Step-by-Step guide to download attachments from Outlook using VB Macro
Step-by-Step guide to writing a VB Script macro for Microsoft Outlook that automatically saves Excel email attachments (xlsx/xls/xlsm/xlsb/csv) to a local Windows folder. Configurable mailbox name + subfolder path; includes folder-not-found error messages.
3 minOpen essay
April 13, 2024
Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Step-by-Step Guide to Solve "Execution of user code in the .NET Framework is disabled. Enable "clr" enabled configuration option."Okay, so what's going on herunre? We are using the custom ".net" code within the SQL Server. We recently migra
1 minOpen essay
April 13, 2024
Microsoft .NET Framework while trying to load assembly. The server may be running out of resources, or the assembly may not be trusted
ALTER DATABASE SET TRUSTWORTHY ON;
1 minOpen essay