I have been searching for a way to move all database files from old drives to new drives. I found this:

http://msdn.microsoft.com/en-us/library/ms345408%28SQL.90%29.aspx

which looks like what this article uses to drive the script. I have followed the Microsoft page above BUT it does not talk about if the environment is a cluster! Since I can't seem to find how to move master within the same instance BUT in a cluster, I tried the web page above.

When I get to the point that I need to move the resource database I cannot log in. So I run this:

NET START MSSQLSERVER /f /T3608

Looks like Sql Server starts from the service, BUT I cannot log into sqlcmd after this:

D:\>D:\MSSQL\90\Tools\binn\sqlcmd.exe -sMSSQLSERVER

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When connecting to SQL Server 2005, this failu

re may be caused by the fact that under the default settings SQL Server does not

allow remote connections..

Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Now, I know this web site instructions work on Sql Server 2005 NONCLUSTERED. I have done this testing 5 times now without issue, but we do not have a clustered test environment to test.

I need to be able to move the resource database on a clustered environment.

Anyone try this?

Our environment:

SQL SERVER 2005 Enterprise 64-Bit SP3

Windows 2003 R2 Enterprise 64-Bit SP2

Any help would be appreciated!