5.8

Procedure
1. Click Start and select Administrative Tools > Services.
2. To stop the SQL Server Reporting Services service, right-click SQLServer Reporting Services
(MSSQLSERVER) and click Stop.
3. Open a command prompt and type iisreset /stop to stop Internet Information Services (IIS).
4. Start SQL Server Management Studio and type the following commands to restore the ReportServer
database.
RESTORE DATABASE [ReportServer]
FROM DISK = N'E:\Backup\ReportServer\ReportServer_backup_201003021337.bak
WITH FILE=1, NOUNLOAD, REPLACE, STATS = 10
GO
5. Click Execute.
6. Right-click SQLServer Reporting Services (MSSQLSERVER) and click Start.
7. In the command window, reset the encrypted key store.
a. Type rskeymgmt –d.
b. When the process prompts you to delete all encrypted data from the report server database, type
y.
8. In the command window, type the following command and verify that it finishes successfully.
rsconfig -c -s <SQLSERVERNAME> -d ReportServer -a Windows
9. Right-click SQLServer Reporting Services (MSSQLSERVER) and click Start to restart the SQL Server
Reporting Services service.
10. In the command window, type iisreset /restart to restart IIS.
Wait for the IIS services to stop and restart successfully.
11. Start Internet Explorer and type http://[SERVERNAME]/Reports/ to navigate to the Report Server
and verify that SSRS is operating properly.
12. In the Report Manager window, click ECMReports.
VCM Backup and Disaster Recovery Guide
36
VMware, Inc.