| Author |
Topic |
|
Newbie777
Starting Member
20 Posts |
 Posted - 2010-11-04 : 13:33:12
|
| Hello,I want to move a couple of databases off of full drives on to another free drive, do I need to be concerned about when working in a clustered environment? thanks. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-11-04 : 16:47:27
|
| Yes, before you can move the databases the other drive has to be added as a cluster resource and added as a dependency for SQL Server. |
 |
|
|
Newbie777
Starting Member
20 Posts |
Posted - 2010-11-05 : 10:57:34
|
| How would I get info to see if it's part of the cluster resource and added as a dependency for SQL Server? Thank you! |
|
|
|
Newbie777
Starting Member
20 Posts |
Posted - 2010-11-05 : 11:10:38
|
| is there any good documentation on moving datafiles in a clustered environment? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-11-05 : 11:18:45
|
quote:
Originally posted by Newbie777
How would I get info to see if it's part of the cluster resource and added as a dependency for SQL Server? Thank you!
use cluster manager for this |
|
|
|
Newbie777
Starting Member
20 Posts |
Posted - 2010-11-05 : 11:26:22
|
| thank you, is there any good doc on moving some user databases in a cluster environment? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-05 : 11:28:20
|
| Same as any other environment.If the drive is not a cluster resource and a SQL dependency, SQL can't even see the drive, it's as if the drive doesn't even exist.--Gail ShawSQL Server MVP |
|
|
|
Newbie777
Starting Member
20 Posts |
Posted - 2010-11-05 : 11:51:24
|
| do you need to shut down the cluster before moving the files for some of the databases? If so, this will affect all the database then. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-05 : 12:53:25
|
| No. No more than you need to shut down SQL or the entire server for moving files on a single instance.The procedure for moving database files in a clustered environment is the same as in a non-clustered environment. The only consideration is the one Jeff brought up, that the new drive needs to be a cluster resource and a dependency on SQL Server.--Gail ShawSQL Server MVP |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-11-05 : 16:00:54
|
| If the drive has not been added as a dependency to SQL Server, you will need to shut down SQL Server to add it. |
|
|
|
|
working in a clustered env.