DB Maintenance

Comments: No Comments
Published on: November 2, 2010

About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server.  It seems to be a rather comprehensive list.  If you don’t have some sort of maintenance checklist yet, I would recommend that you shoot on over and check out his list.  In addition to checking it out, I recommend that you make suggestions of other items to check when doing maintenance.  In addition to getting a maintenance routine setup, I would also suggest that a way to automate as much as possible be explored.

You can find the list here.

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

November 2010
« Oct   Dec »


  • @AngryPets: @pshore73 #sqlhelp Also, the backups veeam created were... crap. (I got called in after 24+ hours of down time and gobs of lost data.)
  • @AngryPets: @pshore73 #sqlhelp Arguably, that was operator error - but any TOOL that would do VSS backups and trim log like that is a FAIL in my book.
  • @AngryPets: @pshore73 #sqlhelp NOT a fan. Had someone call me after they lost 12+ hours of data because veeam did: BACKUP LOG dbName TO DISK = 'NUL'
  • @pshore73: #SQLHelp Any thoughts on Veeam as a tool for production backup & restore of SQL, including performance impacts
  • @paschott: SSIS "Could not load file or assembly" w/ SurveyMonkey DLL. Any ideas? Doesn't seem to be GACable so not sure what next. #sqlhelp #ssishelp
  • @wendy_dance: @hus_sid432 Have you looked at the job history? You can also check in the SSISDB execution logs. #sqlhelp
  • @hus_sid432: Agent job set up as ssis package taking > 12 hrs as suppose to 1hr. How can I troubleshoot #sqlhelp
  • @wendy_dance: @willmeier #sqlhelp Sounds like you need to reinit that subscription. Something may have blocked it, or it only partially completed
  • @mexicanrooster: @whoisyarad I read the next book, highly recommended: Querying Microsoft SQL Server 2012. It covers everything you need. #sqlhelp
  • @willmeier: has anyone had to fix "subscription to publication is not active no user action req"...nothing moving in replication #sqlhelp

Welcome , today is Tuesday, December 1, 2015