Post reply

Strange error in SQL log

  • October 12, 2010 at 10:51 pm

    #241536

    I've got a couple of strange messages in the SQL log:

    SetFileIoOverlappedRange failed, GetLastError is 1314

    It happened when I was attaching a database (mdf and ldf). The DB attached OK and checkdb didn't find any errors.

    Anyone has seen this before?

    By the way, it's SQL 2008 R2 Enterprise on Windows 2008 R2.

    Thanks!

  • October 13, 2010 at 6:57 am

    #1236152

    HI ,

    Which version of SQL are you using and Which version are you attaching from?

  • March 16, 2011 at 12:52 pm

    #1299597

    Did anyone ever figure this message out. I just installed my first Win2008R2 SQL 2008R2 and attached a db backup and got the same message. I ran a DBCC CHECKDB and all is fine.

  • March 16, 2011 at 4:23 pm

    #1299714

    I believe this is an informational message and can be ignored. It's a performance optimisation that can only be used if the SQL Service account has privileges to lock pages in memory (and presumably may also fail under memory pressure).

    More info here:

    http://msdn.microsoft.com/en-us/library/Aa365540

  • March 17, 2011 at 6:11 am

    #1299887

    Ok, thanks for the info.

Viewing 5 posts - 1 through 4 (of 4 total)

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