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

  • i have cluster 2005 64 bit . i need to move all system datbases to other directory. here are the steps i follow but it did not work.

    i took sql related service offline from cluster admin.

    i went to surface area configuration and change master databse files to new location

    started sql from command prompt with -m -T3806 flags (single user mode)

    i open QA and updated data and log file for all rest of three systyem datbaes by deattaching and . sattaching and alter datbase command.

    i run sp_helpdb for all db and confirmed new file location for all system datbase.

    i stopped sql server and the started in normal mode and confirm the same again.

    now stoope sql services again and brought sql services from cluster admin

    to my shock when i connected with cluster and chek path for system datbases it was changed back to old one for all system databases.

    yes i did copy all file including resouce dtabse to new location

    now the problem how i should have changed it that virtual server show my new location when i connect to virtual sql server

    any clue? please advise.

    :crazy: :alien:

    Umar Iqbal