Moving SQL Reporting services databases

Hi
I need to do a SQL Migration for a client and they use SQL Reporting
Services. I cannot find anything on the web on how to move the Reporting
services databases (reconfigure the front end to point to the new RPT
Services databases).
Can you please advise?
Many Thanks
--
Regards
James[MVP]
Visit MBS Blog Central
http://mbscentral.blogs.comYOu have to do a backup and restore in order to use the same Report
definitions as definied in the "old" report server. I big think is to backup
the encryption key where data is encrypted within the ReportServer database.
A good step by step guide is presented here:
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
news:ObCdfnfWFHA.228@.TK2MSFTNGP12.phx.gbl...
> Hi
> I need to do a SQL Migration for a client and they use SQL Reporting
> Services. I cannot find anything on the web on how to move the Reporting
> services databases (reconfigure the front end to point to the new RPT
> Services databases).
> Can you please advise?
> Many Thanks
> --
> Regards
> James[MVP]
> Visit MBS Blog Central
> http://mbscentral.blogs.com
>|||Can you confirm i dont need to worry about the encrption keys since i am
only moving the databases and not the front end of SQL reporting services?
--
Regards
James[MVP]
Visit MBS Blog Central
http://mbscentral.blogs.com
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:%23QbAg7gWFHA.3676@.TK2MSFTNGP10.phx.gbl...
> YOu have to do a backup and restore in order to use the same Report
> definitions as definied in the "old" report server. I big think is to
> backup the encryption key where data is encrypted within the ReportServer
> database. A good step by step guide is presented here:
> http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
> news:ObCdfnfWFHA.228@.TK2MSFTNGP12.phx.gbl...
>> Hi
>> I need to do a SQL Migration for a client and they use SQL Reporting
>> Services. I cannot find anything on the web on how to move the
>> Reporting services databases (reconfigure the front end to point to the
>> new RPT Services databases).
>> Can you please advise?
>> Many Thanks
>> --
>> Regards
>> James[MVP]
>> Visit MBS Blog Central
>> http://mbscentral.blogs.com
>|||Jens,
Do we need to move the visual studio projects physically to new server?
I've copied the encrypted keys and was able to access the web page. I
haven't copied the visual studio projects yet. The old server has two
drives whereas the new one has single drive. I have to change the path
for source cs projects. Any ideas?
Thanks
Tram
Jens S=FC=DFmeyer wrote:
> YOu have to do a backup and restore in order to use the same Report
> definitions as definied in the "old" report server. I big think is to
backup
> the encryption key where data is encrypted within the ReportServer
database.
> A good step by step guide is presented here:
>
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlr=
eportingservices.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
> news:ObCdfnfWFHA.228@.TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > I need to do a SQL Migration for a client and they use SQL
Reporting
> > Services. I cannot find anything on the web on how to move the
Reporting
> > services databases (reconfigure the front end to point to the new
RPT
> > Services databases).
> >
> > Can you please advise?
> >
> > Many Thanks
> >
> > --
> > Regards
> >
> > James[MVP]
> > Visit MBS Blog Central
> >
> > http://mbscentral.blogs.com
> >|||There is no need to reside the VS projects on the server. I our projects we
have the VS projects stored in the VS SourceSafe and on the DevClients.
If you really want to store the projects on the server, just copy them and
change the project / solution source to the new path.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"tram" <tram_e@.hotmail.com> schrieb im Newsbeitrag
news:1116251644.128877.57710@.g44g2000cwa.googlegroups.com...
Jens,
Do we need to move the visual studio projects physically to new server?
I've copied the encrypted keys and was able to access the web page. I
haven't copied the visual studio projects yet. The old server has two
drives whereas the new one has single drive. I have to change the path
for source cs projects. Any ideas?
Thanks
Tram
Jens Süßmeyer wrote:
> YOu have to do a backup and restore in order to use the same Report
> definitions as definied in the "old" report server. I big think is to
backup
> the encryption key where data is encrypted within the ReportServer
database.
> A good step by step guide is presented here:
>
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
> news:ObCdfnfWFHA.228@.TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > I need to do a SQL Migration for a client and they use SQL
Reporting
> > Services. I cannot find anything on the web on how to move the
Reporting
> > services databases (reconfigure the front end to point to the new
RPT
> > Services databases).
> >
> > Can you please advise?
> >
> > Many Thanks
> >
> > --
> > Regards
> >
> > James[MVP]
> > Visit MBS Blog Central
> >
> > http://mbscentral.blogs.com
> >|||Thanks for the quick reply. If I don't copy the projects, if we
shutdown the old server, does it still work?|||When you deploy everything the server needs is stored in the database. The
source is not needed or used. Obviously you want to keep the source for the
reports somewhere to be able to modify easily (although you can extract the
source via the server at a later date).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tram" <tram_e@.hotmail.com> wrote in message
news:1116268553.385098.290120@.g44g2000cwa.googlegroups.com...
> Thanks for the quick reply. If I don't copy the projects, if we
> shutdown the old server, does it still work?
>|||Hi
Thanks for your replies, I am just moving the databases, not the report
services website. I will just do a database restore and follow
http://support.microsoft.com/default.aspx?scid=842425
--
Regards
James[MVP]
Visit MBS Blog Central
http://mbscentral.blogs.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23XcFGzkWFHA.712@.TK2MSFTNGP14.phx.gbl...
> When you deploy everything the server needs is stored in the database. The
> source is not needed or used. Obviously you want to keep the source for
> the reports somewhere to be able to modify easily (although you can
> extract the source via the server at a later date).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tram" <tram_e@.hotmail.com> wrote in message
> news:1116268553.385098.290120@.g44g2000cwa.googlegroups.com...
>> Thanks for the quick reply. If I don't copy the projects, if we
>> shutdown the old server, does it still work?
>