Maintenance Plans

1) Is it a good practice to use the Maintenance Plans to back up the
database, trans logs, and organize the index, and verify the data?
2) How often would it be good practice to run the recreating of index and
verifying the data?
3) Or it's better just create one jobs to backup database etc?
4) Are there any negative to using Maintenance Plans
Thank YouThere are no one size fits all answer for these types of questions. If you have responsibility for
these things, then you have responsibility to understand how backup etc work in SQL Server, learn
how the maint wizard work and based on that make decisions whether maint wiz is good for your
organization. Regarding reindexing, I suggest you read
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Victoria Morrison" <Victoria Morrison@.discussions.microsoft.com> wrote in message
news:CCA01C5B-D86A-4846-8682-50DBA0B24C37@.microsoft.com...
> 1) Is it a good practice to use the Maintenance Plans to back up the
> database, trans logs, and organize the index, and verify the data?
> 2) How often would it be good practice to run the recreating of index and
> verifying the data?
> 3) Or it's better just create one jobs to backup database etc?
> 4) Are there any negative to using Maintenance Plans
> Thank You|||"Tibor Karaszi" wrote:
> There are no one size fits all answer for these types of questions. If you have responsibility for
> these things, then you have responsibility to understand how backup etc work in SQL Server, learn
> how the maint wizard work and based on that make decisions whether maint wiz is good for your
> organization. Regarding reindexing, I suggest you read
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Victoria Morrison" <Victoria Morrison@.discussions.microsoft.com> wrote in message
> news:CCA01C5B-D86A-4846-8682-50DBA0B24C37@.microsoft.com...
> > 1) Is it a good practice to use the Maintenance Plans to back up the
> > database, trans logs, and organize the index, and verify the data?
> >
> > 2) How often would it be good practice to run the recreating of index and
> > verifying the data?
> >
> > 3) Or it's better just create one jobs to backup database etc?
> >
> > 4) Are there any negative to using Maintenance Plans
> >
> > Thank You
>
>