THE SQL Server Blog Spot on the Web

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

Richard Hundhausen: The DBAgilist

This is a mirror of Richard Hundhausen's (aka The DBAgilist) blog "Tales from the Doghouse."

Cool DBA Automation Jobs

I saw a demo of these at Tech-Ed, and thought I would share with my friends.

Essentially, the Database Operations team at Microsoft uses a suite of jobs on all their servers for performing backups, automated database maintenance, improve performance , and improving disaster recovery. I'm sure every SQL Server expert/consultant out there has his or her own bag of tricks, but Microsoft is finally sharing theirs.

 

These SQL maintenance jobs provide automated tasks such as database or transaction logs backup, performing database optimization like Index defrag or update statistics, cleaning MSDB backup history and recycling the SQL error log. Each of these jobs runs stored procedures that are installed when the jobs are created.

 

The following are the jobs get installed with this package.

  • SQLBackupAll
  • SQLBackupDiffAll
  • SQLBackupTranAll
  • SQLBackupChecker
  • SQLDBCCAll
  • SQLIndexDefragAll
  • SQLUpdateStatistics
  • SQLCleanupMsdbBackupHistory
  • SQLCycleErrorLog

Download the automation jobs here, and then refer to the Word document inside.

Published Monday, June 18, 2007 5:16 PM by Tales from the Doghouse - SQLblog
Filed under: ,

Comments

No Comments
Anonymous comments are disabled

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement