Solved

SQL Server Errors

Posted on 2012-03-13
2
1,930 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
2 Comments
 
LVL 39

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

856 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