asked on

Storage is shown as RAW

We have a storage HPMSA1500 connected to our SQL server. SQL server is a hardwarebox(not VM)
Recently there was a power failure. After the power failure storage drive is displaying as RAW.

If I connect to any other device directly I can access the data.

How can i fix this?
screenshots attached.
Capture3.JPG
Capture2.PNG

SOLUTION

Nakul Vachhrajani

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

noxcho

In Windows Disk Management right click on this RAW partition and select Assign a drive letter. Once it is assigned try to access it. If it is accessible - copy out the data and then perform CHKDSK of this volume.

M A

ASKER

@noxcho
Thanks for your comment. I guess you didnt see the attachment.

Nakul Vachhrajani

In the attachment (Capture2.png), no drive letter assignment is seen and the partition type is listed as "Basic" which leads to the conclusion of a corrupt file system.

Did you get a chance to run chkdsk after a backup?

M A

ASKER

please check attachement Capture3.JPG. You can see letter S is assigned to teh drive.
Still I cant access the data.

SOLUTION

noxcho

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

nobus

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

M A

ASKER

I create a new LUN and assigned the same drive letter and copied the data.
Now everything working except SQL server.
All the services of SQL server started except SQL server service.

Nakul Vachhrajani

The startup process must be logging something in the Windows error log. Can you check and share the error number?

It is possible that you have some security issue (configuration), which is causing issues when writing to the disk

M A

ASKER

Below Event IDs logged very 5-10 minutes

17120
17826
17182
26054

Thanks

Nakul Vachhrajani

17182 and 17826 point to registry permissions. 26054 points to encryption and a certificate that is no longer available. You can use "Process Monitor" to monitor the registry keys being accessed during the startup and check for instances where ACCESS DENIED is being reported.

What changed on the server before the drive went bad? Was an encryption in progress when the power failure happened?

M A

ASKER

Thanks