THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Maintenance   (RSS)
Showing page 5 of 5 (47 total posts)
  • More maint procedures

    A few months ago, I blogged about a simple procedure to do backup (http://sqlblog.com/blogs/tibor_karaszi/archive/2007/09/25/tsql-script-to-do-backup-like-maintenance-plans.aspx). Just to let you know that Ola Hallengren has some of his own. Much more elaborate than mine, including things like reorg. Check it out at http://ola.hallengren.com/.
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on January 11, 2008
  • Successful Backup Messages No More...

    How many times have you asked for a way to turn off the behavior in SQL Server that logs successful backup messages to the SQL Server Logs and to the Windows Application Event Logs? If you are like most DBA’s probably a lot. I have been asking for this feature for ages. I have sent email to SQLWish, filed on LadyBug and most recently on Connect ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 29, 2007
  • TSQL script to do backup like Maintenance Plans

    This is frequently asked question, both in forums, as well as in class: How can I though TSQL create new backup files for each backup and have date and time in the file names? The reason for above is most often that you want a higher degree of customization than what maint plans allow for. An obvious such in 2005 is to add the CHECKSUM option to ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 25, 2007
  • Is statistics over non-indexed columns updated by index rebuild?

    Short answer: no.  This question came up today in the MCT discussion group. My gut instinct said no, but I wanted to test it to be certain. But first a brief background: You can rebuild an index using DBCC DBREINDEX or in 2005 (and now preferred) ALTER INDEX ... REBUILD. Rebuilding an index internally creates a new index and when that has ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 9, 2007
  • Be aware: Sp2, maint plans and CHECKDB

    Tony Rogerson brought to my attention that with sp2, a plan that does CHECKDB seems to always do it against the master database. Technicalities seems to be in how SSIS executes SQL commands, separates batches and connection pooling (sp_reset_connection). I created a plan to do CHECKDB against all databases, and this is what I found in my errorlog ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 8, 2007
  • Leaking roof and file shrinking

    Shrinking and growing database files cost you resources and have other side effects as well. I have a technical description  http://www.karaszi.com/SQLServer/info_dont_shrink.asp if you want to get into details about it. Sure, you can have valid reasons to shrink, after archiving lots of data and needing to free some disk space for ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 25, 2007
  • Review your Maint Plans after sp2!

    You might have heard that Maint Plans has had some work on them in sp2. One enhancement is that the Maintenance Cleanup Task now allow for removing of backup files based on hours. This can lead to undesired too early cleanup if you upgraded such a plan. I haven't tested this, I just learned it from the open newsgroups, but my guess is that perhaps ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 25, 2007
Privacy Statement