On 10/2/07, Rick Root <[EMAIL PROTECTED]> wrote: > > > > I can't get rid of it! I've tried doing a full backup, transaction > log backup, shrink database, shrink files, etc.. I'd like to run a > maintenance plan each morning to back up the database completely after > all the morning loads and stuff, then shrink the transaction log > because I don't need it taking up 6 gigs.
You should be able to detach the database, rename the log, and then reattach the database. When you reattach it will look for the log and if not found (because you renamed it) allow you to create a new one. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
