I'm currently running an Active / Passive SQL Server 2005 cluster. I have around 30 databases running on the active node and yesterday I started seeing the following events in the Event Viewer.
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 833
Time: 1:28:35 PM
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [PATH TO THE DATA FILE] in database [MY DATABASE] (11). The OS file handle is 0x00000BB0. The offset of the latest long I/O is: 0x0000035b85c000
This is running on Server 2003 Enterprise 32bit. I have SQL Server 2005 SP2 installed.
They seem to be at odd times and at least once it seems to have caused the cluster to fail over. I've upgraded the drivers for the HP EVO cards but I still got this error a couple of hours later. I've read about some CPU clock timing slipage and I'm still investigating that.
Does anyone else know what might be causing this or could possible give me some direction to start looking?
You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses. You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…