Hello:
I want to extend the SQL server volume (SAN disk)
as the volume is getting nearly full. Can anyone recommend
a procedure that impacts little or nothing?
I am trying to do mount volume to a folder. Does it
help? How does SQL server know about that folder? Can we
assign multiple directories in the SQL sever disk
allocation?
I was told that Veritas Volume Manager or DISKPART
utility may do the job. Did anyone try these tools to
extend the volume without evacuating the data?

Thanks in advance
doc

Mount points are not supported by SQL Server in a cluster,
and even under W2K3 where you can cluster MPs, after the
publication of the SQL 2K HA book, it has come out that it
is not recommended. So that's not an option.

No matter what, you incur some downtime; it's a matter of
what kind. If your SAN supports DISKPART, it is the best
way to go; this also implies you can expand things
properly at the lower level so Windows recognizes it.

If you use VVM on a cluster, Veritas will be your first
point of support for the disk solution.

Remember that under 32-bit, you do have a 2 TB LUN
limitation, and you really don't want to have LUNs that
big anyway.

Thank you for your kind reply. I am on the same page about 'Mount
VOlumes' as they are mostly file server related extensions.
Does anyone try DISPART on SAN (whatever SAN you have) to extend the
existing storage on a production system?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If the LUN gets full, can SQL Server 2K span data over files? Can I add
another LUN/folder when required?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I have a MS SQL Cluster with Active/Active MQ SQL Server on IBM x445 nodes
and IBM FASsT 600 Storage. Since I have couple of LUNs, I had to expand some
of them on several occasions. I used DISKPART, did it all on-line, with no
downtime at all, and the only thing I cared about is to do it at off peak
time (weekend, at night). I extended LUNs in the background on storage
during work days, giving that process low priority, and on sunday afternoon
I did DISKPART extending of volumes. No problems at all.

"Sarma Pisapati" <doc.pisapati (AT) unisys (DOT) com> wrote