February 1, 2010 at 6:42 am
I've been blessed with the opportunity to support SSRS for a vended application's reporting package and some custom reports.
I need to develop operating procedures and processes from scratch because our enterprise has not offered support for SSRS before.
I was hoping to gather some collective wisdom and resources for a few areas of concern:
Security
-- I don't want people developing and writing reports on the production SSRS.
-- I don't want anyone creating new data sources, etc on devleopment w/o my participation.
Change Control
--how do I promote reports/data sources from the development system to the production system?
SQL Data compare? Is there a deployer in BIDS?
Backup & Recovery
--I'm assuming a DB backup of the report server DB will save most of what I need, is there anything else.
Other
--there's a lot I don't know. Are there issues that should be on my radar?
Many thanks in advance,
Craig Outcalt
February 1, 2010 at 6:50 am
definitely, definitely backup the RS encryption Key
read this article about DR for SSRS
http://support.microsoft.com/kb/842425
---------------------------------------------------------------------
February 1, 2010 at 7:07 am
I did find this helpful tool for migrating RS objects around.
Haven't tested it yet:
http://www.sqldbatips.com/showarticle.asp?ID=62
Craig Outcalt
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy