April 27, 2011 at 10:01 am
Can somebody please guide me on how to Move Log File and MSDTC To Different Drive on a SQL Cluster in SQL 2005. I am aware that we should have a shared drive but not sure on the steps.
With Thanks,
Satnam
April 27, 2011 at 11:32 pm
If SQL cluster is in place you can detach and attach log file on the SAN. If not need to set up the cluster and do the detach and attach on the SAN drive.
Make sure you move the log file to SAN drive which is sql server resource else failover of the cluster will fail.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2011 at 10:15 pm
I assume you mean the transaction log file for your database? The critical component of this is to ensure that the disk that you want to move it to is already included in the resource group of the cluster and has the appropriate dependencies in place.
Once you have the disk in place in the cluster resource group then it is simply a case of moving it to the new disk in the same manner as you would do for a non-clustered instance's database.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply