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