Friday, February 24, 2012

Drive missing from Enterprise Manager

Hi,

I have an SQL cluster on Windows 2003 with 2 drives (1 for dbs and 1 for logs). Both of these drives are accessible from Windows explorer.

In Enterprise Manager only the db drive appears as a location to house dbs and logs.

I can't work out how to get the second drive to appear and adding the path manual doesn't work as I end up with the other drive letter appending to the front eg "y:\z:\logs"

Has anyone seen this or have any ideas how to fix it?

Help much appreciated.What's your cluster like? Active/Passive or Active/Active?|||The cluster is active/passive.

Just figured it out, I forgot to add the log drive to the dependennce list for the SQL service.

No comments:

Post a Comment