DBCC CheckDB

How often should we run the DBCC CheckDB ? Do this command automatic
update or fix database if they find error ?Never run with the auto fix. You should decide how ad when to do the fix if
a problem occurs. You should basically run CHECKDB as often as is feasible.
If you have the window then once a night is great but most people only do it
once a week.
--
Andrew J. Kelly
SQL Server MVP
"John Smith" <someone@.nospam.com.us> wrote in message
news:eTs1GZOnDHA.2268@.TK2MSFTNGP12.phx.gbl...
> How often should we run the DBCC CheckDB ? Do this command automatic
> update or fix database if they find error ?
>|||Hi,
If your server is 24 X 7 , Load the latest database backup to the test
environment and run DBCC Checkdb atleast weekly once.
Incase if the output shows errors you can execute DBCC checkdb with REPAIR
options.
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eJm1O#OnDHA.3024@.tk2msftngp13.phx.gbl...
> Never run with the auto fix. You should decide how ad when to do the fix
if
> a problem occurs. You should basically run CHECKDB as often as is
feasible.
> If you have the window then once a night is great but most people only do
it
> once a week.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "John Smith" <someone@.nospam.com.us> wrote in message
> news:eTs1GZOnDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > How often should we run the DBCC CheckDB ? Do this command automatic
> > update or fix database if they find error ?
> >
>|||> Incase if the output shows errors you can execute DBCC checkdb with REPAIR
> options.
The preferred option to recover from such problems is doing a log backup, restoring latest clean
database backup and subsequent log backups. Most cases, repair cannot fix and I wouldn't be
surprised if repair makes on loose the option to do the last tlog backup.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:eR0aNWRnDHA.2416@.TK2MSFTNGP10.phx.gbl...
> Hi,
> If your server is 24 X 7 , Load the latest database backup to the test
> environment and run DBCC Checkdb atleast weekly once.
> Incase if the output shows errors you can execute DBCC checkdb with REPAIR
> options.
> Thanks
> Hari
> MCDBA
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eJm1O#OnDHA.3024@.tk2msftngp13.phx.gbl...
> > Never run with the auto fix. You should decide how ad when to do the fix
> if
> > a problem occurs. You should basically run CHECKDB as often as is
> feasible.
> > If you have the window then once a night is great but most people only do
> it
> > once a week.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "John Smith" <someone@.nospam.com.us> wrote in message
> > news:eTs1GZOnDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > How often should we run the DBCC CheckDB ? Do this command automatic
> > > update or fix database if they find error ?
> > >
> >
> >
>|||Is auto fix a default ? I mean, if I type dbcc checkdb in Query Analyzer
, it will auto fix the databases if there is an error ?
Andrew J. Kelly wrote:
> Never run with the auto fix. You should decide how ad when to do the fix if
> a problem occurs. You should basically run CHECKDB as often as is feasible.
> If you have the window then once a night is great but most people only do it
> once a week.
>|||No, if you specifically issue the DBCC command (vs using the maintenance
plan) you must specify the option to allow it to fix any issues. You must
also set the db to single user mode first.
--
Andrew J. Kelly
SQL Server MVP
"John Smith" <someone@.nospam.com.us> wrote in message
news:%236PBGbZnDHA.2272@.tk2msftngp13.phx.gbl...
> Is auto fix a default ? I mean, if I type dbcc checkdb in Query Analyzer
> , it will auto fix the databases if there is an error ?
>
> Andrew J. Kelly wrote:
> > Never run with the auto fix. You should decide how ad when to do the
fix if
> > a problem occurs. You should basically run CHECKDB as often as is
feasible.
> > If you have the window then once a night is great but most people only
do it
> > once a week.
> >
>