Uploaded August 2012 | Updated September 2026, 2 weeks ago
For more videos on technology, visit Techytube.com
by Jayanth@techytube
A key part of the DBAs day to day activities involve a set of routine tasks that need to be performed in regular intervals. These tasks are essential for the upkeep and smooth performance of the database server as well as to ensure availability. The DBA in any organization is a critical resource and therefore automating these tasks become critical. The maintenance tasks wizard is a key feature available within SQL server that allows to DBA to automate and schedule these tasks in a quick and easy way. The maintenance plans offer the DBA with a significant time saving because it already contains readymade templates that the DBA can use. Compared to some other third party solutions this option works out favourably for those who have basic requirements. Some of the tasks commonly automated include creating database backups, rebuilding or reorganizing indexes etc. These tasks naturally need to be automated and the maintenance itself has options that allow the user to schedule the tasks in SQL Agent.
The maintenance wizard is a powerful tool in the right hands and can easily free up hours from the DBA daily schedule.
For more videos on technology, visit Techytube.com
by Jayanth@techytube
A key part of the DBAs day to day activities involve a set of routine tasks that need to be performed in regular intervals. These tasks are essential for the upkeep and smooth performance of the database server as well as to ensure availability. The DBA in any organization is a critical resource and therefore automating these tasks become critical. The maintenance tasks wizard is a key feature available within SQL server that allows to DBA to automate and schedule these tasks in a quick and easy way. The maintenance plans offer the DBA with a significant time saving because it already contains readymade templates that the DBA can use. Compared to some other third party solutions this option works out favourably for those who have basic requirements. Some of the tasks commonly automated include creating database backups, rebuilding or reorganizing indexes etc. These tasks naturally need to be automated and the maintenance itself has options that allow the user to schedule the tasks in SQL Agent.
The maintenance wizard is a powerful tool in the right hands and can easily free up hours from the DBA daily schedule.
