Home Forums SQL Server 2005 Backups How to restore master database in a SQL Server 2005 Cluster RE: How to restore master database in a SQL Server 2005 Cluster

  • Thanks Tracey and Nary,

    Ok this is just did . Just to make sure its not disk thing issue. I tried moving it from one directory to another directory in the same disk instead of other disk. But I get the same issue.

    Again the problem is that in sql 2005 64 bit cluster chanigng the master database location file directory to other directory on same disk or other disk not working. you can see it new path when you login to node and start sql in single user mode after changing the parameter eith in surface area configuration or registry but when you turn off this instace and start from cluster admin. you see old path when you run sp_helpdb against master.

    Tracey,

    i dd not try removing files from original location i just copy them to new location. I am sure that if i did remove them from original location server would start when i start it from cluster admin since it looks for master files in old direction.

    :crazy: :alien:

    Umar Iqbal