Post reply

Microsoft OLE DB Provider for SQL Server:Fatal error 605 occurred at Jun 12 2008 10:34AM.

  • June 12, 2008 at 11:58 am

    #187879

    Hi Folks,

    One of our users in production got this error while executing a query. Can anyone shed some light on this error please. I know it got to do something with fetching logical page..

    Thanks in advance,

    Razi, M.
    http://questivity.com/it-training.html

  • June 16, 2008 at 1:28 pm

    #829448

    It's usually indicative of some kind of corruption, possibly transient. Run DBCC CHECKDB on the database concerned. If it doesn't turn up anything, it could be a transient problem in the IO subsystem (e.g. stale reads from a disk controller) rather than hard corruption - in which case you should run IO subsystem diagnostics and SQLIOSim.

    It could also be bad memory producing a transient corruption - run memory diagnostics too if DBCC CHECKDB doesn't turn up anything.

    Thanks

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply