SAN Disk with SQL 2000 data files

Hi,
I had a small test setup with an SQL 2000 instance and its data files were
on a SAN disk. After the shutdown following an automatic Windows update
yesterday night, the SAN disk although shows up on the host and also gets
mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
tried unmasking & remasking the LUN to the host, the disk shows up on the
host but I can't access it. Now I want to reformat the disk and put NTFS on
it afresh. But before that, I also want to cleanup the SQL instance and
re-install it. Just uninstalling the SQL instance will do or are there some
standard procedures that I should follow?
Thanks for any pointers!
- VHi
I would find out what the problem really it. It could be a problem with your
HBA driver or similar.
Un-installing SQL Server will not remove the data files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Volcano" <volcano@.volcano.com> wrote in message
news:uumsjmPoFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I had a small test setup with an SQL 2000 instance and its data files were
> on a SAN disk. After the shutdown following an automatic Windows update
> yesterday night, the SAN disk although shows up on the host and also gets
> mounted, I can't "explore" it. It's actually a LUN from an EMC box so I
> tried unmasking & remasking the LUN to the host, the disk shows up on the
> host but I can't access it. Now I want to reformat the disk and put NTFS
> on
> it afresh. But before that, I also want to cleanup the SQL instance and
> re-install it. Just uninstalling the SQL instance will do or are there
> some
> standard procedures that I should follow?
> Thanks for any pointers!
> - V
>