[XenDesktop 7.14.1] XD SQL Transaction log growing excessively

[XenDesktop 7.14.1] XD SQL Transaction log growing excessively

book

Article ID: CTX232943

calendar_today

Updated On:

Description

It has been that the Transaction Log has grown to 175GB abnormaly and taking database backup didn’t shrink them 

Resolution

Method 1:

1. Change the DB recovery mode to "Simple".
2. Back up the database.
3. Shrink the Database > File type choose log.
4. Confirm the shrink succeeds, then change the recovery mode back to "Full".
5. Back up the database for both full and transaction log.
6. Restore the Database with the backup file. (Choose Restore with No recovery when restoring the database and Transaction Logs)

Method 2:

* Execute the following command on principle database
* Backup LOG [XXXX] to disk='nul' //XXXX is database name
* dbcc shrinkfile (N'XXXX_log',1 )

Problem Cause

In SQL 2014 Database we have observed that the Transaction Log has grown to 175GB and taking DB backup didn’t shrink them

Issue/Introduction

The XenDesktop SQL transaction logs grows abnormaly