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