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 h
ave 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/pr...ver/default.asp
http://www.solidqualitylearning.com/
"Victoria Morrison" <Victoria Morrison@.discussions.microsoft.com> wrote in m
essage
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 wo
rk in SQL Server, learn
> how the maint wizard work and based on that make decisions whether maint w
iz is good for your
> organization. Regarding reindexing, I suggest you read
> http://www.microsoft.com/technet/pr...ver/default.asp
> http://www.solidqualitylearning.com/
>
> "Victoria Morrison" <Victoria Morrison@.discussions.microsoft.com> wrote in
message
> news:CCA01C5B-D86A-4846-8682-50DBA0B24C37@.microsoft.com...
>
>