In this article, I will explain
- How to create LOG_BACKUP Maintenance Plan in SQL Server?
- How to restore LOG_BACKUP that have already taken via Maintenance Plan?
Keep in mind
Before you getting started, you should be aware of Continue reading Create a LOG_BACKUP Maintenance Plan in SQL Server
One of the annoying issues that you may experience when you work with SharePoint Databases is
The rapid growth of the SharePoint Config Database transaction log (Full).
So you should regularly maintain the SharePoint_Config Database by taking a backup of the log files frequently to avoid the below-encountered error:
The transaction log for database ‘SharePoint_Config’ is full due to ‘LOG_BACKUP’ (Microsoft SQL Server, Error : 9002)
Note: When The transaction log for database ‘SharePoint_Config’ is full due to ‘LOG_BACKUP’ error is encountered. No transaction or backup action can be performed on ‘SharePoint_Config’ database.
In this article, I’ll show How to avoid falling into this issue (SharePoint_Config Database log file is Full) by following the below steps:
- Shrink the log file to reduce the physical file size.
- Take a Full database backup.
- Create an LOG_BACKUP.
- Create an LOG_BACKUP Maintenance Plan.
Continue reading The transaction log for database ‘SharePoint_Config’ is full due to LOG_BACKUP