Some drives not seen by SQL Server
Posted on 2003-10-27
This is my first question in this area...not interacted with database much before this so consider me naive.
The server is a Dell PowerEdge server with two physical drives (configured as raid 0) and two SAN drives.
local drive was partitioned into C, E and F
the san drives were added as G and H
drive D is CDROM
Operating system is Windows2000 Advanced server
and Database is SQL Server 2000
One of the database was stored (MDF and LDF files) on SAN drives G and H
yesterday all of a sudden the databse was taken into suspect mode and user logins were automatically disabled (maybe due to that).
while investigating more, we found that the SQL server is not detecting both san partitions (G,H) and also local parition E.
first we thought it was a san issue, but san drives and all other drives can be accessed by windows explorer in read write mode.
i found this in the event log
The MSSQLServerADHelper service terminated with service-specific error 3221225572.
but after the SQL server was reinstalled by the admin, this service itself has gone.
all the paritions and drives are shown healthy and active in the disk manager
now what could make SQL server not to see all of them...