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 » backup » Maintenance   (RSS)
Showing page 1 of 2 (12 total posts)
  • March Update to Rules-Driven Maintenance

    This month I have a minor update to the Rules-Driven Maintenance code I originally posted back in August 2012. This update has just two enhancements, but they are nice ones, I think: Much improved handling for instances that use database snapshots. Ability to do intra-day differential backups purely by setting maintenance times and limits ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 11, 2013
  • Update to Rules-Driven Maintenance

    Back in August I posted a first version of a rules-driven solution for backups, index and statistics maintenance and integrity checks. The system in general has been working well, and has saved my team a huge amount of time and effort. We are coming to the anniversary of its use in production soon. Today I offer an update that contains a few ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 16, 2013
  • Backup File Naming Convention

    I have been asked this many times before and again just recently so I figured why not blog about it. None of this information outlined here is rocket science or even new but it is an area that I don’t think people put enough thought into before implementing.  Sure everyone choses some format but it often doesn’t go far enough in my opinion ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 5, 2012
  • 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
  • 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
  • Do you perform log backup for the model database?

    Are you stupid, you might think... But stop and think for a while. Model is no different from other databases. And by default it is in full recovery model. So as soon as you do your first database backup (you do backup your system databases, right?) the log for model will start filling up and autogrow. ''But, hey, I don't do any modifications in ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 18, 2009
  • Do maintenance plans require SSIS?

    To many, this is a non-issue, since SSIS is installed anyhow. But not everyody installs SSIS. I for instance prefer to keep my production systems as clean as possible and only have what I really need (a principle which is harder and harder to live after as years go by...). Also, not all Editions of SQL Server comes with SSIS. I did a ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 26, 2009
  • 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement