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/prodtechnol/sql/2000/maintain/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/prodtechnol/sql/2000/maintain/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/prodtechnol/sql/2000/maintain/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.
>|||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/prodtechnol/sql/2000/maintain/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/prodtechnol/sql/2000/maintain/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.
> >>
> >
>

Maintance Plan dbcc checkdb

Hi,

When I exectue the maintance plan dbcc checkdb it doesn't do anything because it takes 1 second to do de check. Doesn't appers any error.
When I execute the command in the query analizer it takes 2 hours to do the check.

Can you help me?

Thanks,

Marta Masnou

I advice you to forget black box named "maintance plan" and develop your own maintance job. Why? Becouse, in this case you can control all processes which coded by yourself. And catch all necessary information.

For example

Code Snippet

use db_name
create table #result
(
field1,
field2
...
...
)

insert #result exec ('dbcc checkdb with tableresults')

if (select count(*) from #result where status <> 0) > 0
begin
exec master..xp_cmdshell 'net send you_computer "ahtung: db_name is corrupt. Rerun CheckDB"'
end

So, as you can see, if some errors detected, you immediately will receive message.|||Hi,

thanks a lot Alexandr.

Now the job works correctly.

See you soon.

Marta
sql