[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
Was this article helpful?
thumb_up
Yes
thumb_down
No