One of my databases has developed a 32Gb log file (ProductData_Log.LDF) and I can't seem to shrink it.
I have tried... DBCC SHRINKFILE(ProductData_Log, 2) With no luck (although it did report successful completion). I have tried... BACKUP LOG ProductData WITH TRUNCATE_ONLY And... BACKUP LOG ProductData TO [BackupDevice] But nothing works. I have seen people suggesting detaching the database, deleting the log file and then re-attaching the database but this DB is replicated so detaching isn't possible without first breaking the replication and I am reluctant to do that. Anyone else any ideas? -- Jay No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.15/1248 - Release Date: 28/01/2008 21:32 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252283 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
