Hi,
I was upgrading a instance from SQL2000 to SQL2005. During SQL2005 setup I accidently allow the files to be installed in C drive, but I should have them all installed in D drive.
My databases are still sits in D drive, but other files (Management studio, analysis service, etc.) all sits in C drive.
Is there anyway that I can move SQL2005 from C to D drive?
I thought of uninstalling current SQL2005, install it back and load current database to the new sql2005. However I dont have all the passwords of the users. Is there any method that I can solve the problem without removing current users?
Many Thanks,
Nicole