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 » Backup   (RSS)
  • 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
  • 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
  • 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
Privacy Statement