I have sccm in the Always On availability group, the CM database size = 5GB but the log file CM_log.ldf = 50GB,
how can i reduce the size?
If the database is in full recovery mode, the virtual log file cannot be reused if it has not been backed up. This may cause the log_reuse_wait_desc column to report the LOG_BACKUP value.
Please take log backup of the database in the primary replica. And you must have created at least one full backup before you can create any log backups.
Please refer to Create a Full Database Backup and Back Up a Transaction Log which might be helpful.
Once log backup completes, you can consider to shrink the log file to reduce size:
Please check this doc.
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
12 people are following this question.