> Yes, you should backup, optimize and check integrity on
> all your databases. You can do this using a maintenance
> plan. Check BOL
> >-----Original Message-----
> >Hi all,
> >Are there any regular maintenance that should be done on
> a database on a
> >regular basis, someone asked me if I "re-indexed" the
> database regulary.
> >
> >Thanks,
> >Lasse
> >
> >Using MS SQL 2000
> >
> >
> >.
> >