vendredi 10 avril 2015

Migrating SSRS Reports to another server

I am recreating the current ssrs environment for a dev env. I need to move the existing reporting services over to this environment. I need the reports that are deployed there to be deployed in the new dev environment. I installed SSRS in the dev environment and set it up but I obviously don't have any of the reports or data because it's a brand new instance.


This is in SQL Server 2005 with one instance. Can I backup and restore the prod database to the dev database and just point the Report Service to the restored database (under a different name).. and restore the key as well.


Can I do this without taking the prod database offline?


Basically I need to recreate / copy the prod DB to a dev DB in one database server / instance.


Aucun commentaire:

Enregistrer un commentaire