Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Moving sql cluster to new NAS device

Posted on 2010-08-16
2
Medium Priority
?
484 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

721 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