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 schedules with a Reporting Services database

Hi!
I am aware of http://support.microsoft.com/?kbid=842425 which covers the
basics of how to move a Reporting Services database. I additionally
understand about the RSEXECROLE role needing to be added to master and msdb,
with the proper permissions granted, which this article does not mention.
But how are people maintaining the schedules that have been created? It
seems that it is necessary to move Reporting Services' SQL Server Agent jobs
from the one server to the other, so that the schedules that have been
created are transferred. Can someone recommend a way to do this?
Thanks for any enlightenment,
BobIf you are moving the DBs to a new server (not just renaming them), all you
need to do is start the reportserver service. The service will see that the
SQL Agent jobs are missing and populate them all. You will probably want to
delete all the old jobs on the old server as well.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"bobhug" <bobhug@.discussions.microsoft.com> wrote in message
news:A56C6840-13EB-40E3-8E5B-8060AA93FC00@.microsoft.com...
> Hi!
> I am aware of http://support.microsoft.com/?kbid=842425 which covers the
> basics of how to move a Reporting Services database. I additionally
> understand about the RSEXECROLE role needing to be added to master and
> msdb,
> with the proper permissions granted, which this article does not mention.
> But how are people maintaining the schedules that have been created? It
> seems that it is necessary to move Reporting Services' SQL Server Agent
> jobs
> from the one server to the other, so that the schedules that have been
> created are transferred. Can someone recommend a way to do this?
> Thanks for any enlightenment,
> Bob|||Thank you!
"Daniel Reib [MSFT]" wrote:
> If you are moving the DBs to a new server (not just renaming them), all you
> need to do is start the reportserver service. The service will see that the
> SQL Agent jobs are missing and populate them all. You will probably want to
> delete all the old jobs on the old server as well.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "bobhug" <bobhug@.discussions.microsoft.com> wrote in message
> news:A56C6840-13EB-40E3-8E5B-8060AA93FC00@.microsoft.com...
> > Hi!
> > I am aware of http://support.microsoft.com/?kbid=842425 which covers the
> > basics of how to move a Reporting Services database. I additionally
> > understand about the RSEXECROLE role needing to be added to master and
> > msdb,
> > with the proper permissions granted, which this article does not mention.
> > But how are people maintaining the schedules that have been created? It
> > seems that it is necessary to move Reporting Services' SQL Server Agent
> > jobs
> > from the one server to the other, so that the schedules that have been
> > created are transferred. Can someone recommend a way to do this?
> >
> > Thanks for any enlightenment,
> > Bob
>
>

Moving Reporting Services Virtual Directories

Hi
I have followed the aritcle
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk to
a tee, but when i run the new web site i get a page not found for
http://localhost/reports/home.aspx
If i run it on the default web server everything is fine.
I tried testing it by placing an html file in the report manager folder eg
test.html and http://localhost/reports/test.html worked fine.
Has anyone successfully completed this operation? I can access
http://localhost/reportserver/ ok
I'm guessing it's a permissions/execution problem.
Any ideas?
Cheers
JonnyIt's okay
I've sorted it. I hadn't got the ASP.NET server extension enabled in IIS.
Not sure how it worked at all?
Jonny
"Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d8crpk$6d0$1$8300dec7@.news.demon.co.uk...
> Hi
> I have followed the aritcle
> http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> to a tee, but when i run the new web site i get a page not found for
> http://localhost/reports/home.aspx
> If i run it on the default web server everything is fine.
> I tried testing it by placing an html file in the report manager folder eg
> test.html and http://localhost/reports/test.html worked fine.
> Has anyone successfully completed this operation? I can access
> http://localhost/reportserver/ ok
> I'm guessing it's a permissions/execution problem.
> Any ideas?
> Cheers
> Jonny
>

Moving Log Files

Have a look at the following article.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;224071
Peter
MCDBA

>--Original Message--
>I have inherited a SQL Server environment that was
haphazardly installed and managed. I am in the process of
trying to apply some form of structure to this
environment. Currently all data and log files reside in
the default data directory. I am moving the log files to a
separate directory on a different drive. I know I can use
sp_detach_db and sp_attach_db to move the log files, but
how can I move the log files for master, msdb, model, and
tempdb?
>Any help would be greatly appreciated.
>.
>Peter,
Thanks for the prompt reply. This is just what I was looking for.
"Peter the Spate" wrote:

> Have a look at the following article.
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;224071
> Peter
> MCDBA
>
> haphazardly installed and managed. I am in the process of
> trying to apply some form of structure to this
> environment. Currently all data and log files reside in
> the default data directory. I am moving the log files to a
> separate directory on a different drive. I know I can use
> sp_detach_db and sp_attach_db to move the log files, but
> how can I move the log files for master, msdb, model, and
> tempdb?
>

Moving Log Files

Have a look at the following article.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;224071
Peter
MCDBA

>--Original Message--
>I have inherited a SQL Server environment that was
haphazardly installed and managed. I am in the process of
trying to apply some form of structure to this
environment. Currently all data and log files reside in
the default data directory. I am moving the log files to a
separate directory on a different drive. I know I can use
sp_detach_db and sp_attach_db to move the log files, but
how can I move the log files for master, msdb, model, and
tempdb?
>Any help would be greatly appreciated.
>.
>
Peter,
Thanks for the prompt reply. This is just what I was looking for.
"Peter the Spate" wrote:

> Have a look at the following article.
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;224071
> Peter
> MCDBA
>
> haphazardly installed and managed. I am in the process of
> trying to apply some form of structure to this
> environment. Currently all data and log files reside in
> the default data directory. I am moving the log files to a
> separate directory on a different drive. I know I can use
> sp_detach_db and sp_attach_db to move the log files, but
> how can I move the log files for master, msdb, model, and
> tempdb?
>