紧急请救：Sql Server2000不认G盘

[flythinking]

情况是这样的：昨天我们的服务器的系统日志报告如下错误：
SCSI bus fault occurred on Storage Box 0, Port 0 of
Array Controller in slot 6.
This may result in a "downshift" in transfer rate for one or more hard drives on the bus.


Physical Drive on SCSI Port 1, ID 1 of
Array Controller in slot 6 has failed.
Failure Code: 0x07.

Logical Drive 1 of
Array Controller in slot 6 has changed from status code 0 to status code 3.
Status Codes:
0 = OK
1 = FAILED
2 = NOT CONFIGURED
3 = INTERIM RECOVERY MODE
4 = READY FOR RECOVERY
5 = RECOVERING
6 = WRONG PHYSICAL DRIVE REPLACED
7 = PHYSICAL DRIVE NOT PROPERLY CONNECTED
8 = HARDWARE IS OVERHEATING
9 = HARDWARE HAS OVERHEATED
10 = EXPANDING
11 = NOT YET AVAILABLE
12 = QUEUED FOR EXPANSION
13 = UNKNOWN


Logical Drive 1 of
Array Controller in slot 6 has changed from status code 3 to status code 4.
Status Codes:
0 = OK
1 = FAILED
2 = NOT CONFIGURED
3 = INTERIM RECOVERY MODE
4 = READY FOR RECOVERY
5 = RECOVERING
6 = WRONG PHYSICAL DRIVE REPLACED
7 = PHYSICAL DRIVE NOT PROPERLY CONNECTED
8 = HARDWARE IS OVERHEATING
9 = HARDWARE HAS OVERHEATED
10 = EXPANDING
11 = NOT YET AVAILABLE
12 = QUEUED FOR EXPANSION
13 = UNKNOWN

有一块SCSI硬盘出现了问题(做了RAID 5)，指示灯变成红色，后关机，拨出来又插进入，重启，系统自动Recovering后恢复正常，但在这一过程中，操作系统认识G盘，但在sql server中却不能认到G盘，我新建数据库与备份数据库时连G盘都列不出来。
请教各位，如何解决此问题，在下不胜感激!

[zjcxc]

G盘是否NTFS分区,如果是,检查是否给了它everyone访问它的权限.

[flythinking]

真的十分感谢 zjcxc(邹建)
确实是把everyone去掉了，为什么会这样？请zjcxc(邹建) 帮忙解释一下?

[chichunhua]

權限問題

[Well]

G盘是否NTFS分区,權限問題

[zjcxc]

因为你的sql服务的启动用户使用的是"本地系统用户",或者使用的是无G盘使用权限的用户,所以这样就会导致sql server无法访问期间.

[flythinking]

再次感谢zjcxc(邹建)