About database maintenance

Hi Guys,
I have a question regarding database maintenance. I am new dba in a
development team. I don't know what else I need to do except data backup. Do
I need to do rebuild index and update statistic every night? What else do I
neet to do for the database maintenance? Thanks.Without knowing your environment, the most common plans I see are:
Full backup every day
Transaction log backup throughout the day (hourly, 5 minutes, etc.)
Rebuild Indexes weekly
Integrity Check weekly
The maintenance plan wizard can help you set all this up (SQL 2000)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:62D0C100-0CD4-484E-BE8B-A678D6CAAC84@.microsoft.com...
> Hi Guys,
> I have a question regarding database maintenance. I am new dba in a
> development team. I don't know what else I need to do except data backup.
> Do
> I need to do rebuild index and update statistic every night? What else do
> I
> neet to do for the database maintenance? Thanks.|||Thanks you very much. I am development environment. I have a big database fo
r
testing, which I got from production database. Do I need to update statistic
s
every night? Is it enought for me to do the iindex rebuild weekly? what tool
can I use for Integrity Check? dbcc checkdb? thanks.
"Kevin3NF" wrote:

> Without knowing your environment, the most common plans I see are:
> Full backup every day
> Transaction log backup throughout the day (hourly, 5 minutes, etc.)
> Rebuild Indexes weekly
> Integrity Check weekly
> The maintenance plan wizard can help you set all this up (SQL 2000)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:62D0C100-0CD4-484E-BE8B-A678D6CAAC84@.microsoft.com...
>
>|||> Do I need to update statistics
> every night?
Rebuilding indexes will also update statistics on the indexes. Also, the dat
abase option "auto
update statistics" will keep the statistics reasonably updates (in most case
s).

> Is it enought for me to do the iindex rebuild weekly?
It depends on how fragmented the indexes becomes over the week and how much
you suffer from that
fragmentation. See http://www.microsoft.com/technet/pr...
ss2kidbp.mspx

> what tool
> can I use for Integrity Check? dbcc checkdb?
DBCC CHECKDB and on versions prior top 2005 DBCC CHECKCATALOG. I prefer to c
heck as often as I can.
I definitely want to have an unbroken chain of log backups over the time sin
ce last db backup and
the check.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:0CB81AC8-3C62-43CB-90D2-E2BB4671733F@.microsoft.com...[vbcol=seagreen]
> Thanks you very much. I am development environment. I have a big database
for
> testing, which I got from production database. Do I need to update statist
ics
> every night? Is it enought for me to do the iindex rebuild weekly? what to
ol
> can I use for Integrity Check? dbcc checkdb? thanks.
>
> "Kevin3NF" wrote:
>