InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumThu, 24 Sep 2026 11:59:41 GMT20http://forum.strataframe.net/FindPost8917.aspxDoes anybody have any advice/links for information on how to setup a maintenance plan for database(s) in SQL Server 2005?<br> <br> Specifically, in the maintenance plan wizard.. Do I need to run the task labeled 'Check database integrity'? If and when do I need to run the shrink database task? etc.<br> <br> I've found articles explaining what they are and what they do but not so many telling me yes I need to run it or no i dont. ;-)Mon, 21 May 2007 13:23:13 GMTStarkMikehttp://forum.strataframe.net/FindPost8921.aspxYup...TRUNCATE LOG is your friend :)Mon, 21 May 2007 13:23:13 GMTTrent L. Taylorhttp://forum.strataframe.net/FindPost8920.aspxWOW! 25GB! Thanks Trent.Mon, 21 May 2007 13:05:58 GMTStarkMikehttp://forum.strataframe.net/FindPost8918.aspxIt is extremely important that you do three things when maintaining your database.&nbsp; You need to backup, shrink, and flush the logs.&nbsp; An exampe of this is one of our databases that we had missed to flush the logs.&nbsp; The database was 800MB and the log file was 25 GB.&nbsp; After we backed up and added the TRUNCATE LOG the log file wen to 1.5 MB.&nbsp; So it is very important to do this.&nbsp; Your database will also expand with deleted records, so it is good to SHRINK the database relatively often to prevent bloating.&nbsp; And backup is an obvious one, but be sure to add the SHRINK and TRUNCATE LOG to your backups.Mon, 21 May 2007 13:02:06 GMTTrent L. Taylor