Solved

SQL Server Errors

Posted on 2012-03-13
2
1,961 Views
Last Modified: 2012-03-14
Errors started last night on SQL Server, and when our server guy rebooted a whole drive disappeared and he had to rebuild the partition. From what I've read these errors mean that there is a an IO subsystem issue, where SQL Server is having difficulty talking to one of the drives. I read that it can happen with SAN multipathing and connectivity- but I really have no idea what I'm talking about. My boss wants me to figure out what caused these errors. Here they are in order:



LogWriter: Operating system error 21(The device is not ready.) encountered.

The log for database 'Administration' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

fcb::close-flush: Operating system error (null) encountered.

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0000000000000000 in file 'E:\SqlData\Administration.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.

A file activation error occurred. The physical file name 'E:\SqlData\Administration.LDF' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Any help is much appreciated.
0
Comment
Question by:new_to_networks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 37716403
"My boss wants me to figure out what caused these errors. "

Tell him/her that a bad SQL record scratched one HardDisk sector from your SAN and caused the failure and the error below :)

"The log for database 'Administration' is not available.
...
The operating system returned error 21(The device is not ready.) "

No you can't really say that and that is the problem - I don't think anyone would be able to say 100% what really caused a hard disk failure unless they know they hit it it hard with a hammer while it was on line.

My 1cent.:)
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37717745
I agree.  The correct answer as lcohan has stated is:
You can't do that
http://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=23
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How are passwords stored in Active Directory 25 147
Time sync on Domain 5 42
Server 2008 Not services listed 23 50
IIS Authentication Error 401 16 16
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.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question