Environment:sqlserver2008R2 instance on windows server2008R2 2-node cluster.
I want to copy data files of system database in a seperate folder,but as service is running, it is not allowing me to copy.
If i stop the service, then second node gets activated.
If I make the instance offline, then drive is not accessible.
so how to move data files of system database to a seperate folder.
Are you talking about master or resource database?
If that's the case, I'm afraid that's not so easy as you think. Because when the SQL service starts, it checks for the default location, so you need to change it when SQL is down or offline.
Also, remember than in a Cluster, you must use the Cluster Admin console to deal with SQL service and moving resources, not the default Windows service applet. So you take the service offline, but you work on the active node. Taking the instance offline won't take the drives or LUN offline, at least, not in the active node. Taking the SQL service offline will only stop SQL server.
This link may help you, I think: Move System Databases