July 28, 2011 at 2:37 pm
I'm getting multiple SQL errors on a SBS2008 server. I'm a bit perplexed at it all and don't know where to start, I'm not a SQL or Sharepoint person so that doesn't help. About every 30 minutes the Applications log explodes with a list of SQL errors for:
SQLVDI event id: 1
MSSQLSERVER event id: 3041 and 18210
SQLWRITER event id: 24583
MSSQL$SBSMONITORING event id 3041 and 18210
MSSQL$MICROSOFT##SSEE event id: 3041 and 18210
The 18210 errors for SQLWRITER or MSSQL$MICROSOFT##SSEE are always:
The description for Event ID 18210 from source <SQLWRITER or MSSQL$MICROSOFT##SSEE> cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
The event is always something different. Either pertaining to Backups of some kind or Sharepoint
The MSSQLSERVER and MSSQL$SBSMONITORING 18210 and 3041 errors are these:
18210 - BackupVirtualDeviceFile::SendFileInfoBegin: failure on backup device '{A9AE340F-5DC5-4061-A4E8-B5A21AD3FC99}3'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
3041 - BACKUP failed to complete the command BACKUP DATABASE <model, report server, master, SBSMonitoring, msdb, etc> . Check the backup application log for detailed messages.
SQLWRITER event id 24583 is always somethign to this effect:
The description for Event ID 24583 from source SQLWRITER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
ICommandText::Execute
0x80040e14
SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 10.0
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3271
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 10.0
Error message: A nonrecoverable I/O error occurred on file "{F45C634B-B3E8-412F-AF89-1A6C64761698}8:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQLSTATE: 01000, Native Error: 4035
Error state: 1, Severity: 0
Source: Microsoft SQL Server Native Client 10.0
Error message: Processed 0 pages for database 'master', file 'master' on file 1.
the message resource is present but the message is not found in the string/message table
And finally the SQLVDI event id 1:
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=3444. Thread=11172. Server. Instance=MICROSOFT##SSEE. VD=Global\{F45C634B-B3E8-412F-AF89-1A6C64761698}7_SQLVDIMemoryName_0.
There are SceCli warnings event id 1202 pertaining to GPO permissions. The users are MSSQLFDLauncher, SQLSERVERAGENT, and MSSQLSERVER.
And finally the Sharepoint errors are
Event id 3760 - SQL Database 'ShareWebDb' on SQL Server instance 'LAW-SERVER\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.
Cannot open database "ShareWebDb" requested by the login. The login failed.
Event id 5215 - Unable to connect to database. Check database connection information and make sure the database server is running.
Event Id 6398 - The Execute method of job definition Microsoft.SharePoint.Administration.SPImmediateAlertsJobDefinition (ID 2ffbbc12-3b56-4abf-80d8-3c669644e270) threw an exception. More information is included below.
Unable to connect to database. Check database connection information and make sure the database server is running.
I hope I didn’t just destroy your brains because I don’t even know where to start with this one. They have been getting intermittent slow downs on the network with a program called Client Profiles which uses SQL and these are the only errors in the logs. I can’t find anything else that would cause slow downs over the network.
Thanks,
Adam
July 28, 2011 at 2:50 pm
Start with the last one. It says you're missing a database on an instance of SQL Server. Have you checked to see if that database exists on that server? If so, is it online and accessible?
On the others, those are I/O errors, and I'd start with checking the drive it's trying to write backups to. Is the drive available? Does it have room on it for the backups? Are the permissions set up for writing to it?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 2, 2011 at 1:08 pm
SQL issues was due to an admin user that was only listed as public permissions and also not listed to the correct DB.
SceCli was easy enough to fix, just had to find the GPO that the incorrect users were in, I followed the procedure listed in the error log itself and got that taken care of.
Sharepoint I'm working on when I have the chance, but the errors are apparently not critical so it's not a huge rush.
It's really nice to not see my event logs filled with red x's though that's for sure. Thanks for the help!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply