dbcc checkdb('db_prod')

Last Post 19 Oct 2010 08:16 PM by ctseah. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ctseah
New Member
New Member

--
15 Oct 2010 01:34 AM
Hi,

I am using sql 2008 sp1.
It is necessary to run the command dbcc checkdb('db_prod') with NO_INFOMSGS ??
What is the advantage of running the above command as part of administration effort ?
Is there a better way of do it such as schedule it as a job (using SQL Agent) ?
What kind of performance impact on my production server when running such as command ?

My currently 'db_prod' has a size of 9GB Data and 6GB Logs.

Thanks in advance.

Regards
gunneyk
New Member
New Member

--
15 Oct 2010 04:28 AM
DBCC CHECKDB is a way to verify the integrity of your database. It will detect things like corruption, out or range values, invalid pointers etc. The idea is that if corruption occurs you want to find out in a timely manor so you have the best chance of repairing the corruption without loss of data. To run DBCC CHECKDB on a 9GB DB should only take a few minutes to run and I would recommend setting up a SQL Agent job to run it nightly. It's always best to run it at a time with least activity on the server.
J013-B
New Member
New Member

--
15 Oct 2010 10:27 AM
Adding with no_infomsgs just leaves out informational messages when you run the command. It is common to run dbcc checkdb () with no_infomsgs, all_errormsgs when investigating potential corruption in a database so you only get error messages from the command and know where to focus your efforts if there is corruption with a table/index.
ctseah
New Member
New Member

--
18 Oct 2010 12:51 AM
Hi,

Thanks.
Should I use the maintenance plan wizard to perform this task ?

Regards
gunneyk
New Member
New Member

--
19 Oct 2010 04:15 PM
Thats up to you. It doesn't do anything special but it's fine to use it as well.
ctseah
New Member
New Member

--
19 Oct 2010 08:16 PM

Hi,

Thanks, have scheduled it as part of the maintenance plan.

Tested it to be working fine.

regards

You are not authorized to post a reply.

Acceptable Use Policy