Sunday, February 20, 2022

DBCC ShrinkFile. Transaction Log Full on SQL Server database.

 


Backup and log full errors are handled as follows:

Tran log full:
https://blog.devoworx.net/2016/04/26/the-transaction-log-for-database-sharepoint_config-is-full-due-to-log_backup/

If you are unable to perform any of the previous alternative solutions. In this case, you can perform a shrink operation to reduce the physical file size. By running the following below commands.

--  This example is  for a database named sharepoint_config. Substitue your database here
use sharepoint_config
go
alter database sharepoint_config set recovery simple
go
dbcc shrinkfile('SharePoint_Config_log',100)
go
alter database sharepoint_config set recovery FULL
go

No comments: