Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Refresh test reporting server with production reports server backup Expand / Collapse
Author
Message
Posted Thursday, August 22, 2013 7:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 4:03 PM
Points: 64, Visits: 312
I need to clone ssrs test and development from production reporting environment.
I am planning to backup reportserver, reportservertempdb, encryption key in production and restore on both test and dev server.
Is this going to work? Thanks for your suggestions.
I also wanted to download all rdl files at once to put on source control but i guess that is a seperate questions.

Post #1487247
Posted Thursday, August 22, 2013 7:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
Both possible.

for downloading rdl files use rsscripter(free).


Regards
Durai Nagarajan
Post #1487266
Posted Sunday, August 25, 2013 3:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 4:03 PM
Points: 64, Visits: 312
Thanks.
There are so many things to consider like service account, encryption key, subscriptions etc when i refresh test enviromnet with production.
Can anyone tell me what are the steps i need to do after i restore the production database in test environment?
Can i override test encryption key with production encryption key?
Is there any case where i need test encryption key?
Is deploying reports through a project solution at once is better than restoring database and doing several step?
(considering that there will be more than 10 project files which goes to 10 different folders)


Post #1488254
Posted Monday, August 26, 2013 1:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
[b]Can anyone tell me what are the steps i need to do after i restore the production database in test environment?

restore the excryption key and check the reports.


Can i override test encryption key with production encryption key?

you can restore encryption key


Is there any case where i need test encryption key?

yes , backup before you go for resore it with production keys, sometimes SSRS will stop functioning.


Is deploying reports through a project solution at once is better than restoring database and doing several step?
(considering that there will be more than 10 project files which goes to 10 different folders)


It is up to you , remember existing reports in test server will vanish along wiht your DB, so if you want then you can use RSScripter to download and upload in the same folder structure.


Regards
Durai Nagarajan
Post #1488312
Posted Monday, August 26, 2013 1:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
[b]Can anyone tell me what are the steps i need to do after i restore the production database in test environment?

restore the excryption key and check the reports.


Can i override test encryption key with production encryption key?

you can restore encryption key


Is there any case where i need test encryption key?

yes , backup before you go for resore it with production keys, sometimes SSRS will stop functioning.


Is deploying reports through a project solution at once is better than restoring database and doing several step?
(considering that there will be more than 10 project files which goes to 10 different folders)


It is up to you , remember existing reports in test server will vanish along wiht your DB, so if you want then you can use RSScripter to download and upload in the same folder structure. you have to configure datasource and permissions manually.


Regards
Durai Nagarajan
Post #1488313
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse