hmmm... i think i have simply deleted one, and it simply created one itself, but dont take that as the answer... PURELY a last option case that i KINDA remember from years ago.
honestly, this post is worthless so just disregard it anyway :) hope you figure it out. tw On Jan 29, 2008 10:00 AM, James Smith <[EMAIL PROTECTED]> wrote: > 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:252306 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
