hmm ok, the enumavailablemedia is pretty straight forward but i cant find any usage info for enumdirectories. Currently my treeview is populated with 2 logical drives and some folder entires...

set up a simple server side trace and leave it running for a day or so. Should be able to find out/what is changing the status!

has the TCP/IP port number been changed under TCP/IP settings?

David, this parameter stops the service being updated (i.e. running/stopped/etc) in the services.msc

Flo\Barry

thanks a lot, i only need the drive name and then the folders underneath. I'll check out the items posted and see how i get on

Regards

Perry

samsql

to start, can you please post the following info

SQL server version/edition:

OS version/edition:

min memory for sql:

max memory for sql:

you say the server has 16GB ram is that correct?

what exactly do you...

i need to populate a treeview object with fixed drives and their folders

did you remember to add the extra required resources under cluster administrator for disk, IP, Name, etc.

your 2nd instance will use separate disk resources, etc 😉

i take your point, the point of investing in a SAN though is you can lose a switch or a disk and the array is still available. The OP states...

incidentally, exactly where did you change the sql service account credentials from local to domain user?

absolute rubbish, the whole point of a SAN is multi pathing and fail over. Chances are, if...

i would migrate all data to the new SAN and setup database mirroring between the 2 instances. Decommission the old Hitachi SAN unless you have any real need to keep...

for sql 2008 clustering post in the sql 2008 forum in the future.

Apart from that this should help too

http://www.mssqltips.com/tip.asp?tip=1698

sql 2000 let you do a whole load of...

using either profiler or a server side trace!