Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Maintenance Tasks for SQL Server



By:

Overview

SQL Server databases require regular maintenance and this can be a time consuming process. MS SQL Server has a built-in tool which makes it easier to create and execute maintenance tasks. This tool is known as the Maintenance Plan Wizard.

Explanation

The Maintenance Plan Wizard can be started from SQL Server Management Studio and can be found in the Management section of the tree in SSMS. It creates scheduled jobs which are run by the SQL Server Agent and can perform the following tasks:

  • Reorganize index pages
  • Rebuild indexes
  • Update statistics on the indexes
  • Shrink data and log files by removing empty pages
  • Backup database and transaction log
  • Perform internal consistency checks
  • Cleanup tasks
It is worth it to set up maintenance plans to make these every day tasks much easier.  

Additional Information


Last Update: 5/27/2011




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools