February 15, 2005 at 9:55 am
Has anyone seen this behavior before? I am running SQL 2000 Enterprise on a clustered server ( Win 2000 Advanced server). The C and D drives are on Raid 5, I have an additional K drive on the same machine but not part of the raid. I use the K drive for backing up the log files. The backup is working fine, however when I try to access this drive via enterprise manager it is not detected, initially this was not the case. More puzzling Windows sees all drives.
Any help would greatly be appreciated. Thank you in advance.
February 15, 2005 at 10:00 am
Check the security on the K: drive - make sure the user account that EM uses to connect to the server has permissions on the drive (EM executes a system sproc called xp_availablemedia to enumerate available drives, where "available" depends on filesystem security).
February 16, 2005 at 12:17 am
Also if the K: is a cluster resource, use Cluster Administrator to ensure that the sql node is the current owner of the resource (if you are not familiar with Cluster Administrator, locate someone who is!, or you could find yourself with a broken cluster).
February 17, 2005 at 5:52 am
In Cluster Administrator, make sure all drives you use are listed as Dependencies for the "SQL Server" resource.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply