** Private ** wrote: > One of my databases has developed a 32Gb log file (ProductData_Log.LDF) and > I can't seem to shrink it.
Switch your database to simple logging, run a checkpoint and the dbcc_shrinkfile. When it has completed, switch your database back to full logging and then create a maintenance plan that performs a regular backup of the transaction logs. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:252326 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
