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,
You probably have to deploy your reports again using Visual Studio.|||YOu can do a backup and restore on the new server of the Report Server database. You will additionally have to backup the encryption key from the old server using the configuration utility and apply / restore it on the new one as the content of the database is encrypted and cannot be decrypted without the key of the old server.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment