Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sawag
Starting Member
5 Posts |
 Posted - 2010-08-28 : 16:38:36
|
| Hi,We have SQL 2005 in cluster environment. The databases are stored on SAN Storage. Now we have the shortage of space on SAN Storage and want to attach a new SAN storage and move all SQL databases on new SAN. Now please guide how can we achieve this;1. How can we move the SQL databases on new SAN? What is the recommended procedure?2. We want to remove the old SAN. How will we handle the cluster as the quorum is configured in old SAN. if we remove old SAN after attaching the new one with the servers, the cluster will stop work as the quorum was configured on old SAN. In this case what should we do? Can we move (copy/paste) the quorum also to the new SAN and configure the cluster with the new quorum drive (is it possible in windows cluster?) OR we will need to recreate everything (SQL cluster etc)? |
|
|
BISWAJIT74
Starting Member
5 Posts |
Posted - 2010-09-21 : 18:13:47
|
| We gone throw the same procedure , here i am writing.1) Take the sql server offline2) tell your window administrator to attach the new SAN (let S , T)3) COPY your data file or log file from OLD SAN ( let say P,Q) TO NEW SAN (S,T)4) RENAME THE OLD SAN TO SOME DIFFERENT NAME 5) RENAME YOUR NEW SAN TO YOUR OLD SAN NAME (LIKE P,Q)6) UP THE SQL SERVER CLUSTER 7) DO TEH FAILOVER8) ALL TASK DONE :)Biswajit Das |
 |
|
|
sawag
Starting Member
5 Posts |
Posted - 2010-09-22 : 06:55:14
|
| Hi,thanks for the reply. for the copy, i need to use simple copy and paste or copy the data with xcopy command? |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-09-22 : 07:16:36
|
| 0) TAKE FULL BACKUPS AND TEST THEMCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
|
|
SQL in cluster environment