Error Log error log

Published on May 7th, 2015 | by Alejandro Cordero

0

SetFileIoOverlappedRange failed, GetLastError is 1314

Error Message:

SetFileIoOverlappedRange failed, GetLastError is 1314

Cause:

When attaching a database:

SQL Server Service User is using lock pages in memory, as specified in this link. When another user that does not have lock pages in memory tries to attach a database, you will see in the SQL log a Warning message like

SetFileIoOverlappedRange failed, GetLastError is 1314

or a Windows bug(happening even if not attaching a database)

This is a documented event in this KB https://support.microsoft.com/en-us/kb/2679255/en-us

 

Solution:

If you get the error while attaching a database this message can be ignored, you can avoid that message from happening by assigning lock pages in memory privilege to the windows user doing the database attach operation. If the error happens even when not attaching a database plan a windows patch as specified in this kb.

 

These are quick references by SQLTurbo, intended for quick review of commands
and quick solutions to common sql errors. This section does not elaborate
on topics deeply. However feel free to comment and we will try to make
suggestions as needed.


About the Author

SQL Server DBA with over 8 years of experience, developer for .Net , Certified Scrum Master and Entrepreneur.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed


    sqlturbo.com A SQL Server Web Blog
    Canada, Ontario, Ottawa.
    http://sqlturbo.com

    The Authors