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.
>>
>>
>

Moving ReportServer and ReportServerTempDB to a different drive.

I need to move these databases from the C to the E driver on the existing server. I found instructions on how to move to a different server but I could not find specific instructions on moving these databases on what I need to dor. Has anyone been successfully in moving these databases to a different drive? If so, I would be grateful in you sharing your knowledge.

Thanks.

While these databases contain metadata for SSRS, they are not particularly special otherwise, just detach/re-attach them as you would any other database :)

If you're unclear on how to attach/detach, take a look at the sp_attach_db and sp_detach_db sprocs in books online (FYI, SSRS will need to be shut down while you do this or you won't be able to detach in the first place since it will have open connections)

Hope this helps!

|||I am familiar with the attach and detach stored procedures, so I will try this out on one of our virtual servers. Thanks a lot.

Moving Published db to different server (cannot reinitialize)

Paul, Hilary , anyone.
Do you guys have a step by step instructions on
how to move a db to another publisher without
reinitializing? Isn't there like a "no sync"
option. I have seen you guys talk about
sometjhign of that sort in here. These tables we
replicate are too big to have to create new
snapshots and send them over. I want to avoid
the whole process and just pick up where it left
off after the db is moved. Can this be done just
using enterprise manager and not query analyzer?
Thanks,
comb
Do a final sync and stop the agents. Then do your move and do no sync
subscriptions.
This should work.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1c20e370aa015dab989701@.news.newsreader.co m...
> Paul, Hilary , anyone.
> Do you guys have a step by step instructions on
> how to move a db to another publisher without
> reinitializing? Isn't there like a "no sync"
> option. I have seen you guys talk about
> sometjhign of that sort in here. These tables we
> replicate are too big to have to create new
> snapshots and send them over. I want to avoid
> the whole process and just pick up where it left
> off after the db is moved. Can this be done just
> using enterprise manager and not query analyzer?
> Thanks,
> comb
|||In article <erYjhRU3EHA.2788
@.TK2MSFTNGP15.phx.gbl>, hilary.cotter@.gmail.com
says...
> Do a final sync and stop the agents. Then do your move and do no sync
> subscriptions.
> This should work.
>
thanks. Can i do no sync option from Enterprise
Manager. I don't recall seeing that
Thanks
-comb