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

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks.
"Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)