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.