Having issues with backing up SSRS for SQL Server 2008
-
We have an old server running SQL Server 2008 SSRS. We are in the planning stages of upgrading the Windows Server OS as well as the SQL Server version and need to backup the SSRS database and encryption keys so we can upgrade (same hardware, just in-place upgrades).
When I run this rskeymgmt command I get an error.
-------------------------------------------------------------------------------------------------------------
rskeymgmt -e -i MSRS10_50.TCM94SSRS -f C:SSRSKeys -p ######## -t
System.Exception: Unable to locate the Report Server Windows service for instanc
e MSRS10_50.TCM94SSRS. ---> System.IO.FileNotFoundException: The system cannot f
ind the file specified. (Exception from HRESULT: 0x80070002)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 e
rrorCode, IntPtr errorInfo)
at RSRemoteRpcClient.Utilities.RPCEndpointFromInstanceName(String instanceNam
e)
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.get_RpcEndpoint()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.get_RpcEndpoint()
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args, Bas
eCmdLine instance)
---------------------------------------------------------------------------------------------------------
How can I back all this up? I'm not an experienced SQL Server admin, just a Windows Server admin so this is all Greek to me. My SQL team says I need to backup the SSRS key and databases so they can be restored when we migrate up to SQL Server 2012
Any detailed instructions are GREATLY appreciated!
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
Backup your SSRS Databaes(ReportServer and Report Server Temp DB and Any other DB needed) using Microsoft SQL Server Managment Studio:
And Backup your Encryption Key using Report Server Configuration Manager.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply