Have Geek Brain

What is the use of maintenance plans in SQLSERVER2005

What is the need and use of sqlserver maintenance plans and how do I set them up?

0


a source to share


5 answers


Google explains everything: http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx



+2


a source


They simplify the creation of scheduled backups, reindexing, and other maintenance tasks. Its a simple wizard that asks you what you want to do, to which databases and how often.



+1


a source


Service plans

Maintenance plans create a workflow with the tasks required to keep your database optimized, regularly backed up, and inconsistent. Such maintenance tasks can be performed manually or automatically on a schedule. - Source: MSDN

+1


a source


The maintenance plan provides you with its own tools to keep your SQL Server running. You can schedule tasks such as index maintenance, database backups, etc. As part of a maintenance plan (see also SQL Server Agent). Check out the nearby StackOverflow site, ServerFault, for related questions. I've seen a guru on ServerFault answering queries like this. Check http://sqlserverpedia.com/ you can find useful information on the website .; -)

0


a source


In simple terms, maintenance plans are a basic tool for automating specific SQL Server tasks using SQL Server Integrations Services (SSIS) components.

Typical use cases:

  • Optimizing indexes
  • Database backups
  • Clearing Job History

They also handle the creation of supporting components such as jobs and schedules.

If you have a simple or simple database, then service plans can usually meet all your needs. Database administrators (DBAs) in more complex environments usually prefer to implement their own solutions for these scenarios.

0


a source






More articles:


All Articles