Rick Root wrote: > I have a database in SQL Server 2005 that generates a lot of > transactions each morning at 7am due to the bulk loading of data, > dropping and recreating indexes, etc. > > Currently, the transaction log file is about 6 gig. > > 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.
Switch to Simple recovery mode, checkpoint and shrink the database. Then switch back to Full recovery. To manage the issue on a more permanent basis set up a management job that does a transaction log backup. Once transaction logs are backup up they will be overwritten. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
