Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 db consistency

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-06 : 20:05:32
Asad writes "I have a report that is generated each day that tells me some what of status of DB.

For the first time in the report I see an item as follows:

DB Consistency = 2 followed by the table name.

Can someone please provide info on this.

Thanks."

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-04-17 : 17:20:28
This is a daft question. What does your report do? What does that output mean?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-04-17 : 18:04:42
I'm guessing that as you say this is unuasual that it is saying that there is a problem with the table.
You could try running a dbcc checktable on it.
The report might just be saying that the is something wrong with the data in the table though.

Doesn't anyone there know what this report is for?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -