Maintenance Plan

hello everybody
Our Production DB is growing around 25 MB per day , is it necessary to have
a maintenance plan for our production database. If it is necessary than how
frequent it should be done & what we needs to included in that maintenance
plan. Can somebody provide me a maintenance plan.
regards
You can find some general guidelines in the System
Administration chapter of the Operations Guide at:
http://www.microsoft.com/technet/pro...n/sqlops4.mspx
but your specific needs will depend upon business needs, the
type/usage of databases, etc.
-Sue
On Wed, 29 Sep 2004 08:55:41 +0530, "uppal"
<compaq@.smil.co.in> wrote:

>hello everybody
>Our Production DB is growing around 25 MB per day , is it necessary to have
>a maintenance plan for our production database. If it is necessary than how
>frequent it should be done & what we needs to included in that maintenance
>plan. Can somebody provide me a maintenance plan.
>regards
>
sql

Mail Using SMTP Server

Have anyone been able to set up mail using a SMTP server successfully?
Is it necessary to have a mailbox for outgoing mail on the SMTP server?
Thanks
LystraTry this.

C:\Backup\Db Maint SMTP Alerter.htm|||Please explain yourself, is this suppose to be a link?

Lystra|||Sorry, I put the wrong address. Try this: http://sqldev.net/xp/xpsmtp.htm. On this website , you can found the XPsmtp configuration, I even used it on my server a couple months ago, they work well.