July 2, 2012 at 6:22 am
Hello I am getting this error in the logs:
The operating system returned error 21(failed to retrieve text for this error. Reason: 15105) to SQL Server during a write at offset 0x00000000364000 in file 'E:\SQLData\MSDBData.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
When I try to run a Check DB i get this error
A database snapshot cannot be created because it failed to start.
Msg 7928, Level 16, State 1, Line 1
The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Can anyone advise ?
July 2, 2012 at 6:23 am
What is the exact statement you are running?
Jared
CE - Microsoft
July 2, 2012 at 6:30 am
DBCC CHECKDB
AND
DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS
Same result
July 2, 2012 at 7:49 am
is SQL Server Running under Local system account or Domain account?
If is running under Domain Account check permissions under SQL Server Data Folder where is located your msdb database.
July 2, 2012 at 7:54 am
carlos.sfc (7/2/2012)
is SQL Server Running under Local system account or Domain account?If is running under Domain Account check permissions under SQL Server Data Folder where is located your msdb database.
+1 See this thread, it points to the exact same issue: http://qa.sqlservercentral.com/Forums/Topic450261-146-3.aspx
Jared
CE - Microsoft
July 2, 2012 at 8:03 am
OS error 21 means "the device is not ready", so, as the error message suggests, you probably have something wrong with your disk. I'm not sure whether the error you get when you run DBCC CHECKDB is a symptom of the same problem. Do you have a backup of the database that you can restore on to another server and run DBCC CHECKDB there?
John
July 2, 2012 at 8:05 am
SQLKnowItAll (7/2/2012)
carlos.sfc (7/2/2012)
is SQL Server Running under Local system account or Domain account?If is running under Domain Account check permissions under SQL Server Data Folder where is located your msdb database.
+1 See this thread, it points to the exact same issue: http://qa.sqlservercentral.com/Forums/Topic450261-146-3.aspx
Have checked the permissions on this folder, and the domain account has full permissions
July 2, 2012 at 9:58 am
John Mitchell-245523 (7/2/2012)
OS error 21 means "the device is not ready", so, as the error message suggests, you probably have something wrong with your disk. I'm not sure whether the error you get when you run DBCC CHECKDB is a symptom of the same problem. Do you have a backup of the database that you can restore on to another server and run DBCC CHECKDB there?John
Your saying restore the msdb on another server why? what will this prove ?
July 3, 2012 at 1:31 am
Well, you say that you can't connect to the database where it is to run a DBCC check. Therefore you don't know what't wrong with the database. If you can restore it to another server and run the check there, you'll be able to find out what kind of corruption, if any, there is.
John
July 3, 2012 at 12:29 pm
Please check --> http://support.microsoft.com/kb/926070
Do you have enough space on the disk?
What is the database size?
What is the free space on the disk?
July 3, 2012 at 12:40 pm
Verify that your antivirus is not blocking database files.
Check: Directories and file-name extensions to exclude from virus scanning
http://support.microsoft.com/kb/309422
http://www.symantec.com/business/support/index?page=content&id=TECH176828
July 3, 2012 at 1:02 pm
Also, Verify if your anti-virus is not blocking database files.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply