Solved

Moving sql cluster to new NAS device

Posted on 2010-08-16
2
471 Views
Last Modified: 2013-11-14
I currently have a Windows\SQL cluster running on a few lefthad NAS iSCSI storage devices
We just bought EMC storage, and need a plan on how to transfer the sql database,
shares, and etc. From the old lefthand devices to the new EMC storage via ISCSI

We need to decomission the old lefthand devices and have the cluster use the new EMC device.
How do I go about doing this, while reducing errors, and minimizing impact to users.

0
Comment
Question by:bntech
2 Comments
 
LVL 2

Expert Comment

by:SushiFrito
ID: 33448168
Depending the database size, you can stop the SQL Server service and move the data files.
0
 
LVL 1

Accepted Solution

by:
bntech earned 0 total points
ID: 33449786
My question is twofold.
(1) would i have to break the cluster then add the new storage to the cluster -- What is best way to do this,
I would have to create a new qurom and etc.
(2) copying the data, \ SQL database from one storage array to the other.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now