Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

moving data files of system databases in cluster Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 4:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
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.
Post #1398298
Posted Wednesday, December 19, 2012 8:24 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:25 AM
Points: 384, Visits: 1,265
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
Post #1398443
Posted Wednesday, December 19, 2012 8:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 5,222, Visits: 5,079
Why do you want to copy them?

What is the reasoning behind your task?




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1398445
Posted Wednesday, December 19, 2012 8:30 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
thanks..will try and let you know...
Post #1398450
Posted Wednesday, December 19, 2012 8:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:25 AM
Points: 384, Visits: 1,265
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 ...
Post #1398471
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse