i hope this is the right forum
i've been going through my sql logs and have noticed that every 10 seconds, a line is being written to a logfile, along the lines of:
2012-11-23 07:50:32.34 spid79 Attempt to fetch logical page (1:30555) in database 24 failed. It belongs to allocation unit 72057594063618048 not to 72057594056540160.
2012-11-23 07:50:34.30 spid66 Error: 824, Severity: 24, State: 2.
2012-11-23 07:50:34.30 spid66 SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xf651d46b; actual: 0x6290fff5). It occurred during a read of page (1:30196) in database ID 24 at offset 0x0000000ebe8000 in file 'F:\myFolderStructure\RedGateMonitor.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2012-11-23 07:50:46.82 spid87 Error: 605, Severity: 21, State: 3.
i have spotted this great articlehttp://www.sqlservercentral.com/articles/Corruption/65804/
and feel that running an integrity check is the best course of action. this seems to involve running CheckDB.
the article states this can take a long time, so out of hours would be best. i'm wondering whether it will make any changes, or if it is just an 'evidence gathering' tool?
if it is just gathering evidence, i would be quite happy to run it and see what it flags. if not, i would be abit more hesitant to run it as i'm not quite sure what it would be doing and what sorts of things i should be aware of first.
The reason i ask is because this link seems to be suggesting that it is/can do more than just checking.http://www.sqlservercentral.com/Forums/Topic1232926-2893-1.aspx#bm1233046