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 2 of 5 (48 total posts)
  • Backup and the evil RETAINDAYS option

    ''So what bad has this option done?'', you probably as yourself. Well, not much, but I find it evil because it confuses people, especially those new to SQL Server. I have many times seen people specifying something like 3, and expect SQL Server to keep the three most recent backups in the backup file and overwrite everything which is older than ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 8, 2012
  • Analyzing the errorlog

    How often do you do this? Look over each message (type) in the errorlog file and determine whether this is something you want to act on. Sure, some (but not all) of you have some monitoring solution in place, but are you 100% confident that it really will notify for all messages that you might find interesting? That there isn't even one little ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 5, 2012
  • Ola Hallengren's maint procedures now supports logging to table

    This can for instance be very useful if you want to keep track how long time things take, over time. Check them out here.Version history here.
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 15, 2011
  • Article released about moving databases

    Just a short notice that I've released an article about moving databases between SQL Server instances: You find it at http://www.karaszi.com/SQLServer/info_moving_database.asp.
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 10, 2011
  • Using the catalog views : clearing out a "botched" schema

    A user on StackOverflow had populated a custom schema with a bunch of tables, and needed to replace them with a new set of tables due to various changes. But he couldn't just drop them all in any arbitrary order, because there were foreign keys in place. His workaround was to just run a ''drop all tables'' script multiple times until there were no ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 7, 2011
  • Project Atlanta Has a New Name

      Brad Anderson just completed a keynote in Las Vegas at the Microsoft Management Summit 2011 and announced the new name for what was originally called Project Atlanta. Dot da da dah… And the new name is:  System Center Advisor.  You can find much more information at www.SystemCenterAdvisor.com.  The product also goes from a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on March 22, 2011
  • A more reliable and more flexible sp_MSforeachdb

    I've complained about sp_MSforeachdb before.  In part of my ''Bad Habits to Kick'' series in 2009-10, I described how I worked around its sporadic inability to actually process all of the databases on an instance: http://sqlblog.com/blogs/aaron_bertrand/archive/2010/02/08/bad-habits-to-kick-relying-on-undocumented-behavior.aspx I ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 29, 2010
  • SQL Server Backup Simulator

    The SQL Server support team just announced the release of a backup simulator. Many 3rd party utilities that do backup like IBM Tivoli, Symantec BackupExec, Quest Litespeed, Redgate SQL Backup etc. use the sqlvdi.dll to communicate to SQL Server and this allows you to simulate that activity. So if you want to test how your system reacts or more ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 28, 2010
  • Why we never want to trick SQL Server into rebuilding a log file

    ''Never'' is a strong word, so let me say that we really really want to avoid it, if at all humanly possible. In short, we will have a (potentially) broken database, both at the physical level and at the logical level. Read on. Just to be clear, when I refer to a ''log file'' here, I'm talking about a transaction log file, an .ldf file. Ever so ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 14, 2010
  • Ola Hallengren's maint procedures now supports exclusions

    Ola has a set of stored procedures to do maint operations, see http://ola.hallengren.com/. Ola has now updated them to support exclusions or inclusions of tables, indexes or even whole schemas from index rebuild/reorg. Check out http://ola.hallengren.com/Documentation.html#SelectingIndexes for info on how to define exclusions and ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 9, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement