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. How do I do this? -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:289944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
