March 12, 2012 at 6:17 pm
Hi,
Some how my all SSRS Data source has been dropped from server Not Sure may be someone accidently deleted that Data Source Folder.
I have DR server which i synced with this server few days back, now i need to coping all Data Source only from DR server to that another server.
Is there a way to coping all data sources from DR to Prod Server??
All the help would be greatly appreciated.
March 13, 2012 at 2:30 am
There is a tool called RSScriptor which will script out and restore them but you will need to modify the batch file it creates to restore to the right server.
Alternativly you can backup the SSRS encryption keys on production, and backup restore the DR report server database then restore the encryption keys, that is of course if no new reports have been added to production since the last sync.
Or you can manually re-create them in the SSRS homepage.
March 14, 2012 at 5:12 am
+1 for RSScripter http://www.sqldbatips.com/showarticle.asp?ID=62
I've just moved a huge server full of reports including datasources and subscriptions from sql 2005 to sql 2008 using it. It's free and easy enough - just read the documentation.
March 14, 2012 at 2:28 pm
Thanks RSScripter Works great..:)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply