Skip to content

Stored Procedure Based Maintenance Solution for Backup, Integrity Check and Index Optimization

May 4, 2008

[Here’s an email from Ola Hallengren]


I have a solution that I would like to share with the SQL Server
community. It’s a stored procedure based maintenance solution for
backup, integrity check and index optimization.

The backup stored procedure supports full, differential and log
backup. It creates backup directories, backups databases, verifies
backups and deletes old backups.

The stored procedure for index optimization does index rebuild online
or offline, index reorganization, statistics update, index
reorganization and statistics update or nothing based on fragmentation
level, LOB existence and index size.

Best regards

Ola Hallengren


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

  • Archives

  • RSS SQLServerPedia

  • RSS SQL Crunch – Hot SQL Links

  • My Bookmarks

  • Business Career DBA Tool Events free ebook Humor IT News Members Only Microsoft MySQL Operating System Oracle Personal Reporting Services SQL Server SQLServerPedia Syndication SSC SSIS TSQL Tutorial Uncategorized Video

  • Software Blogs - BlogCatalog Blog Directory
  • %d bloggers like this: