Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to move data files in cluster environment

Status
Not open for further replies.

seiamerica

Technical User
Dec 27, 2005
13
US
we have data files in D partitions and indexes on E and logs in F partitions.
we are planning to regroup the partitions so that data will be on d and index and log files in E partition. How to do it in cluster environment.

Thanks in advance
 
You do this just like it's a non-clustered SQL Server. Log onto the active node, detach the database, move the files to the correct place, and reattach the database.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top