We have a sql server 2005 cluster on a Windows 2003 server. I need to move the master and resource
databases to a new drive. I was able to move the master fine...but when I tried to start sql server
in single user mode using the following command:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>
xe -f -c -T3608 -sMSSQLSERVER
It runs thru a bunch of different users not allowing me to connect. See the screen shot below.
Any idea on how I can start the server in single user mode or just move the resource database?