Re: Moving a SQL 2005 2-node, single-instance cluster to new SAN hardware



Yep. Russ looks like he has the right steps. As he correctly noted, SQL only cares about drive letters when resolving file paths. I have done data moves like this in the past and it works as advertised.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Jeff Swearingen" <jeffvswearingen@xxxxxxxxx> wrote in message news:1191615753.522674.247760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I have seen various posts on how to move SQL databases files on an
existing SAN to a new SAN. Geoff, Rod, Russ and others have provided
valuable suggestions.

I need help clarifying something -- although the files can be moved by
following some steps very carefully, do the SQL instances need to be
re-installed or re-configured in any way?

Environment:
- Two-node, single-instance running SQL Server 2005 Enterprise
- Existing SAN (older IBM DS400)
- New SAN (newer IBM DS4700)
- The SQL program files are installed to the local C: drives of each
node and the log/data files are on partitions residing on the SAN.
Also on the SAN are the Quorum and other application-specific cluster
resources.

I plan to follow the steps outlined in Russ' blog post:
http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61741.aspx

Any suggestions are welcome.

Thanks,
Jeff


.



Relevant Pages

  • Re: Move SQL 2000 data to new SAN, same drive letter
    ... I have done this before except it was remapping the drive letters to new ... LUNS on the same SAN. ... The key is to make sure SQL is shut down cleanly and ... Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: Multi-Channel Raid VS SAN Storage
    ... The idea of keeping the database in memory is appealing, ... Our report SPs are vry tempDB and memory intensive. ... Probably because our SQL server only has 3 GB of RAM. ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Add new cluster and use existing LUNs?
    ... Meta-volumes are dedicated to a single host, single activity (OS, swap file, ... varied activity (DBMSes, Messaging Server, File Server, Web Servers, ... Some of the physical spindle limitations can be addressed through the SAN ... >> test would be to run a simulated SQL I/O load on the newly created LUNs ...
    (microsoft.public.sqlserver.clustering)