Moving RS 2005 Reports to new server

Hi Guru,
Currently, we are running our RS 2005 reports on our old hardware and
wanted to move them to better server where I'll be building it
tomorrow. On the existing server, we installed both database and
reporting services running on the same box but I'm ONLY planning to
install reporting service on the new server.
What are the options to move RDL, shared data sources, shared
schedules, jobs to the new server? I heard people talked about backing
up and restore both ReportServer and ReportServerTempdb databases to
the new server would do it. How can I restore or attach these two dbs
to new server when we don't plan to install database services on it?
Please help!
Thanks,
Silaphet,If you are moving only RS and plan on the databases used by RS for its
metadata/object caching to stay where it is then you definitely are not
going to want to touch the databases. When you mention the RDL, shared
datasource, etc etc. These are all in the database. There are no files. You
only need the application to be moved and then pointed to the database. RDL
only exists on the development. When you deploy they are compiled and stored
in the database.
If you have enterprise then you should just treat this like a web farm and
install the new one and have both using the same databases and then remove
the old one once done. Otherwise you need to remove the old one and then
install the new. When you install the new you point it to the databases.
Standard edition does not support web farm (multiple RS all using the same
databases), only enterprise.
Here is a link that deals with totally moving RS (the app and the supporting
databases) which might help you understand the pieces but isn't quite what
you are doing:
http://support.microsoft.com/default.aspx?scid=842425
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<smounkhaty@.bremer.com> wrote in message
news:1165856070.452398.223800@.73g2000cwn.googlegroups.com...
> Hi Guru,
> Currently, we are running our RS 2005 reports on our old hardware and
> wanted to move them to better server where I'll be building it
> tomorrow. On the existing server, we installed both database and
> reporting services running on the same box but I'm ONLY planning to
> install reporting service on the new server.
> What are the options to move RDL, shared data sources, shared
> schedules, jobs to the new server? I heard people talked about backing
> up and restore both ReportServer and ReportServerTempdb databases to
> the new server would do it. How can I restore or attach these two dbs
> to new server when we don't plan to install database services on it?
> Please help!
> Thanks,
> Silaphet,
>