[MS SQL]Could not allocate space for object 'XXX'.'YYY' in database 'distribution' because the 'PRIMARY' filegroup is full
之前遇到幾個DB問題，環境大概是多台DB做點對點交易式複寫 (Peer-to-Peer Transactional Replication)，至於這是怎麼運作的可以參考這幾篇文章：
http://caryhsu.blogspot.tw/2012/03/sql-server-nlb.html
http://www.dotblogs.com.tw/jerrymow/archive/2010/12/29/20447.aspx
原本都Run的好好的，今天早上一上班信箱就開始被failed mail塞爆，這對以往沒有管過DB的我，腎上腺素直直上升阿(一定是沒買乖乖的關係…)，所以一定要來記錄一下。
首先去Log查看，發現有以下錯誤：
Could not allocate space for object 'XXX'.'YYY' in database 'distribution' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, addingadditional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
嗯…錯誤訊息很明顯…大概就是資料滿了，所以找了好久，最後至下方調整：
在'distribution' 點選右鍵->Properties
選擇Files tab->點選initial size下的按鈕
調整Maximum File Size至Unrestricted File Growth，再去跑JOB就正常執行了(呼)!
--
Reference
http://support.powerdnn.com/KB/a132/error-could-not-allocate-space-object-x-dabase-your.aspx
