XenDesktop 5 Database Transaction Log Growing Excessively

XenDesktop環境では必ずやりましょう。

[現象 Symptoms]
Citrix XenDesktop 5.0 database transaction logs are growing rapidly, which might result in running out of disk space and the inability to connect to clients.
Microsoft SQL Server のトランザクションログがものすごい勢いで増えて、ディスク不足になり接続不可となる。

[原因 Cause]
The XenDesktop database contains both configuration and state information which must be updated often.
A single Virtual Desktop Agent doing nothing for an hour generates approximately 62 kilobytes of transaction log data.Number of Virtual Desktop Agents X 24 Hours X approximately 62 kilobytes of data
Virtual Desktop Agent (VDA)が生成するデータがめちゃ多いのでパンクします。
時間あたり62kB生成するので、2万クライアントと想定すると、一日に
20,000 [VDA] × 62 [kB] ×24 [H] ≒ 28 [GB] 　ひーーーー。

[解決 Resolution]
Ensure that the database is configured to use the Simple recovery model as described below.
Note: This procedure does not apply if using database mirroring which requires the Full setting.参照もとは、こちらです。
http://support.citrix.com/article/CTX126916

Set the database recovery model to Simple.
Select Database then right click.
Select Properties.
Select Database Options.
Under Recovery Model select Simple.