I am getting some strange issues with our MS SQL 2008 database where intermittently we lose connection to the db for 10+ seconds or so. The db is stored on a SAN over fiber. The latest event log error I get is "LogWriter: Operating System error 1 (incorrect function) encountered with an event ID of 17053. Following that error is event ID 9001 about log for database is not available. I would then see a message stating recovery is completed for database in 12 seconds. Not sure how to approach this and any help or guidance would be much appreciated. Running MS SQL 2008 on Windows 2008 SP1.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You need to either have a SAN admin look at the system of bring a consultant in to look at it. (Yes I'm a SAN consultant, no that's not why I'm saying this.)