Maintenance

Hi NG,
Before doing a backup of our databases I would like to execute a DBCC
checkdb command. Is this enough for a daily maintenance plan?
Is there a white paper for the daily maintenance of a MSS database?
Thank you in advance.
You can the maintenance plan wizard to do this for you buy doing an
integrity check periodically and check the "perform these checks before
doing backups" box.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Praetorian Guard" <praetorian@.gatekeeper.com> wrote in message
news:OCzkILMyFHA.3312@.TK2MSFTNGP09.phx.gbl...
> Hi NG,
> Before doing a backup of our databases I would like to execute a DBCC
> checkdb command. Is this enough for a daily maintenance plan?
> Is there a white paper for the daily maintenance of a MSS database?
> Thank you in advance.
>
|||The SQL Server 2000 Operations Guide has a System
Administration section which covers recommended daily,
weekly, monthly tasks.
http://www.microsoft.com/TechNet/pro...n/sqlops0.mspx
-Sue
On Tue, 4 Oct 2005 17:05:33 +0800, "Praetorian Guard"
<praetorian@.gatekeeper.com> wrote:

>Hi NG,
>Before doing a backup of our databases I would like to execute a DBCC
>checkdb command. Is this enough for a daily maintenance plan?
>Is there a white paper for the daily maintenance of a MSS database?
>Thank you in advance.
>
|||... and also read http://www.microsoft.com/technet/pro...ss2kidbp.mspx.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:dkq4k1pleke9o2gs97fiqjcu17l3edvja0@.4ax.com...
> The SQL Server 2000 Operations Guide has a System
> Administration section which covers recommended daily,
> weekly, monthly tasks.
> http://www.microsoft.com/TechNet/pro...n/sqlops0.mspx
> -Sue
> On Tue, 4 Oct 2005 17:05:33 +0800, "Praetorian Guard"
> <praetorian@.gatekeeper.com> wrote:
>
|||Thanks guys!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OmtFvuOyFHA.2500@.TK2MSFTNGP10.phx.gbl...
> ... and also read
http://www.microsoft.com/technet/pro...ss2kidbp.mspx.[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:dkq4k1pleke9o2gs97fiqjcu17l3edvja0@.4ax.com...
http://www.microsoft.com/TechNet/pro...n/sqlops0.mspx
>