moving system databases

I want to move the system databases and tried following the instructions
from: http://support.microsoft.com/kb/224071 (How to move SQL Server
databases to a new location by using Detach and Attach functions in SQL
Server).
It didn't work. Adding the startup parameters "-c -m -T3608" does not change
the error message when issuing sp_detach_db that system db's can't be
detached.
I have a feeling this has something to do with the active/passive cluster,
but can't figure out how to get around it.Is this 2005? If so there are very specific and different instructions for
2005 for each of the system dbs.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Jay" <nospan@.nospam.org> wrote in message
news:uAxKciLHIHA.5276@.TK2MSFTNGP04.phx.gbl...
>I want to move the system databases and tried following the instructions
>from: http://support.microsoft.com/kb/224071 (How to move SQL Server
>databases to a new location by using Detach and Attach functions in SQL
>Server).
> It didn't work. Adding the startup parameters "-c -m -T3608" does not
> change the error message when issuing sp_detach_db that system db's can't
> be detached.
> I have a feeling this has something to do with the active/passive cluster,
> but can't figure out how to get around it.
>|||Sorry, it is 2000.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OWv0H3LHIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Is this 2005? If so there are very specific and different instructions
> for 2005 for each of the system dbs.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:uAxKciLHIHA.5276@.TK2MSFTNGP04.phx.gbl...
>>I want to move the system databases and tried following the instructions
>>from: http://support.microsoft.com/kb/224071 (How to move SQL Server
>>databases to a new location by using Detach and Attach functions in SQL
>>Server).
>> It didn't work. Adding the startup parameters "-c -m -T3608" does not
>> change the error message when issuing sp_detach_db that system db's can't
>> be detached.
>> I have a feeling this has something to do with the active/passive
>> cluster, but can't figure out how to get around it.
>|||Just a thought, did you actually restart the server after adding the
parameters?
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Jay" <nospan@.nospam.org> wrote in message
news:udwIhvMHIHA.6068@.TK2MSFTNGP05.phx.gbl...
> Sorry, it is 2000.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OWv0H3LHIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Is this 2005? If so there are very specific and different instructions
>> for 2005 for each of the system dbs.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uAxKciLHIHA.5276@.TK2MSFTNGP04.phx.gbl...
>>I want to move the system databases and tried following the instructions
>>from: http://support.microsoft.com/kb/224071 (How to move SQL Server
>>databases to a new location by using Detach and Attach functions in SQL
>>Server).
>> It didn't work. Adding the startup parameters "-c -m -T3608" does not
>> change the error message when issuing sp_detach_db that system db's
>> can't be detached.
>> I have a feeling this has something to do with the active/passive
>> cluster, but can't figure out how to get around it.
>>
>|||Pleeeese!
I'm nearly certian that I need to change the other node in the cluster for
it to take. Probably going to have to wait for the weekend.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%234atq%23NHIHA.2100@.TK2MSFTNGP03.phx.gbl...
> Just a thought, did you actually restart the server after adding the
> parameters?
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:udwIhvMHIHA.6068@.TK2MSFTNGP05.phx.gbl...
>> Sorry, it is 2000.
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:OWv0H3LHIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Is this 2005? If so there are very specific and different instructions
>> for 2005 for each of the system dbs.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uAxKciLHIHA.5276@.TK2MSFTNGP04.phx.gbl...
>>I want to move the system databases and tried following the instructions
>>from: http://support.microsoft.com/kb/224071 (How to move SQL Server
>>databases to a new location by using Detach and Attach functions in SQL
>>Server).
>> It didn't work. Adding the startup parameters "-c -m -T3608" does not
>> change the error message when issuing sp_detach_db that system db's
>> can't be detached.
>> I have a feeling this has something to do with the active/passive
>> cluster, but can't figure out how to get around it.
>>
>>
>|||OK, changing the second node in the cluster does nothing as changing the
active changes that value. So that's not it.
If I take the '-c -m -T3608' and split it into 3 seperate startup options,
On restart I get the message:
A connection could not be established to _SERVER_
Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
in single user mode. Only one administrator can connect at a time.
I am rdp'ed into the box and no one else is on.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%234atq%23NHIHA.2100@.TK2MSFTNGP03.phx.gbl...
> Just a thought, did you actually restart the server after adding the
> parameters?
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:udwIhvMHIHA.6068@.TK2MSFTNGP05.phx.gbl...
>> Sorry, it is 2000.
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:OWv0H3LHIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Is this 2005? If so there are very specific and different instructions
>> for 2005 for each of the system dbs.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uAxKciLHIHA.5276@.TK2MSFTNGP04.phx.gbl...
>>I want to move the system databases and tried following the instructions
>>from: http://support.microsoft.com/kb/224071 (How to move SQL Server
>>databases to a new location by using Detach and Attach functions in SQL
>>Server).
>> It didn't work. Adding the startup parameters "-c -m -T3608" does not
>> change the error message when issuing sp_detach_db that system db's
>> can't be detached.
>> I have a feeling this has something to do with the active/passive
>> cluster, but can't figure out how to get around it.
>>
>>
>