What is the maintenance plans?
What is the difference between 2000&2005 when it comes to maintenance Plans?
Please provide your answer to me in simple way, so that i can understand
Thanks And Regards, T.Anil Kumar.
Maintenance plans are the tools by which you can do the most common database maintenance tasks like Backups, index rebuild/reorganize , stats update etc..
SQL Server 2000 database maintenance plans were Transact-SQL commands run by SQL Server Agent jobs. In SQL Server 2005, maintenance plans are created as SSIS packages.
Kindly have a look at below link to see how to create maintenance plan
- Chintak (My Blog)
Microsoft는 Msdn 웹 사이트에 대한 귀하의 의견을 이해하기 위해 온라인 설문 조사를 진행하고 있습니다. 참여하도록 선택하시면 Msdn 웹 사이트에서 나가실 때 온라인 설문 조사가 표시됩니다.