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.
| Author |
Topic |
|
wardsan
Starting Member
48 Posts |
 Posted - 2010-09-02 : 05:58:52
|
| Hi folks,what I am trying to do is run a dbcc checkdb to a file and then check that file for consistency/allocation errors. I was trying to use windows findstr but not getting very far. Would anyone have any suggestions? I basically just need to know if there are any consistency or allocation errors, it doesn't matter how it's done. TIASandra |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-02 : 07:01:11
|
| UseDBCC CHECKDB (MyDatabaseName) WITH NO_INFOMSGSand you will only get some output if there is a problem that needs attention. Might that help?You may also want to add the options EXTENDED_LOGICAL_CHECKS, DATA_PURITY for more detailed checking (I think that EXTENDED_LOGICAL_CHECKS is a SQL 2008 option) |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
script to look at output of dbcc checkdb