December 19, 2012 at 4:33 am
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.
December 19, 2012 at 8:24 am
charipg (12/19/2012)
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
December 19, 2012 at 8:27 am
Why do you want to copy them?
What is the reasoning behind your task?
December 19, 2012 at 8:30 am
thanks..will try and let you know...
December 19, 2012 at 8:50 am
charipg (12/19/2012)
thanks..will try and let you know...
Did you see Anthony's post? that's a good comment that I forgot to ask or mention.
Are you running out of space? Why are you moving those critical files to a different location. That may be more important to know than actually moving those files ...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply