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
Additional Information
- Performing maintenance tasks in SQL Server article on MSSQLTips
- Maintenance Tips category on MSSQLTips
I am a technical and business professional based in Budapest, Hungary. I am working in the financial industry on the operations side, but also have test management experience in the educational software domain. My experience includes Microsoft SQL Server 2000-2012, IBM DB2 and MySQL database administration, troubleshooting, migration and development. My focus points are performance tuning and security. I am passionate about sharing my knowledge with the greater audience.
I hold MSc degree in Engineering and Management. I am married and I have a beautiful daughter.
LinkedIn account:
http://www.linkedin.com/in/nagytibor
Twitter account:
https://twitter.com/#!/tnagy_eeft
