Moving the Report Server Databases to Another Computer

When doing the manual restore method, I got the "The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported) (rsRPCError) " message. The following is from http://blogs.imeta.co.uk/swildgoose/Default.aspx and assisted me in resolving this error.

Restoring the reporting database from another machine will import the reporting services encryption keys from the source machine. Running the Standard (not Enterprise) version of Reporting Services with multiple encryption keys is not possible. Attempting to run the reports up in a website will result in the following error:
The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported) (rsRPCError)
This error message is essentially saying that running Reporting Services with multiple encryption keys is not possible without upgrading to Reporting Services Enterprise edition. Fortunately the solution (from http://support.microsoft.com/?kbid=842425) is simple.
Run
>> rskeymgmt -l
to determine the guid of the source encryption key. then run
>> rskeymgmt -r <src_id>
to remove the source key.

The original first uses 'with copy_only' which means you can't backup logs. The original second uses files made with a different script than the first.

First:

-- To permit log backups, before the full database backup, alter the database
-- to use the full recovery model.
USE master;
GO
ALTER DATABASE ReportServer
SET RECOVERY FULL

-- If the ReportServerData device does not exist yet, create it.
USE master
GO
EXEC master.dbo.sp_dropdevice @logicalname = N'ReportServerData'
GO
EXEC sp_addumpdevice 'disk', 'ReportServerData', 'C:\ReportServerData.bak'

-- Create a logical backup device, ReportServerLog.
USE master
GO
EXEC master.dbo.sp_dropdevice @logicalname = N'ReportServerLog'
go
EXEC sp_addumpdevice 'disk', 'ReportServerLog', 'C:\ReportServerLog.bak'

-- Back up the full ReportServer database.
BACKUP DATABASE ReportServer
TO ReportServerData
--WITH COPY_ONLY

-- Back up the ReportServer log.
BACKUP LOG ReportServer
TO ReportServerLog
-- WITH COPY_ONLY

-- To permit log backups, before the full database backup, alter the database
-- to use the full recovery model.
USE master;
GO
ALTER DATABASE ReportServerTempdb
SET RECOVERY FULL

-- If the ReportServerTempDBData device does not exist yet, create it.
USE master
GO
EXEC master.dbo.sp_dropdevice @logicalname = N'ReportServerTempDBData'
go
EXEC sp_addumpdevice 'disk', 'ReportServerTempDBData', 'C:\ReportServerTempDBData.bak'

-- Create a logical backup device, ReportServerTempDBLog.
USE master
GO
EXEC master.dbo.sp_dropdevice @logicalname = N'ReportServerTempDBLog'
go
EXEC sp_addumpdevice 'disk', 'ReportServerTempDBLog', 'C:\ReportServerTempDBLog.bak'

-- Back up the full ReportServerTempDB database.
BACKUP DATABASE ReportServerTempDB
TO ReportServerTempDBData
-- WITH COPY_ONLY

-- Back up the ReportServerTempDB log.
BACKUP LOG ReportServerTempDB
TO ReportServerTempDBLog
-- WITH COPY_ONLY

second:

--NOTE: It is not a best practice to put mdf-s or ldf-s on the OS drive or the same drive.

-- Restore the report server database and move to new instance folder
RESTORE DATABASE ReportServer
FROM DISK='C:\ReportServerData.bak'
WITH NORECOVERY,
MOVE 'ReportServer' TO
'G:\Databases\ReportServer\ReportServer.mdf',
MOVE 'ReportServer_log' TO
'D:\Databases\ReportServer\ReportServer_Log.ldf';
GO

-- Restore the report server log file to new instance folder
RESTORE LOG ReportServer
FROM DISK='C:\ReportServerLog.bak'
WITH NORECOVERY,
MOVE 'ReportServer' TO
'G:\Databases\ReportServer\ReportServer.mdf',
MOVE 'ReportServer_log' TO
'D:\Databases\ReportServer\ReportServer_Log.ldf';
GO

-- Restore and move the report server temporary database
RESTORE DATABASE ReportServerTempdb
FROM DISK='C:\ReportServerTempDBData.bak'
WITH NORECOVERY,
MOVE 'ReportServerTempDB' TO
'G:\Databases\ReportServer\ReportServerTempDB.mdf',
MOVE 'ReportServerTempDB_log' TO
'D:\Databases\ReportServer\ReportServerTempDB_Log.ldf';
GO

-- Restore the temporary database log file to new instance folder
RESTORE LOG ReportServerTempdb
FROM DISK='C:\ReportServerTempDBLog.bak'
WITH NORECOVERY,
MOVE 'ReportServerTempDB' TO
'G:\Databases\ReportServer\ReportServerTempDB.mdf',
MOVE 'ReportServerTempDB_log' TO
'D:\Databases\ReportServer\ReportServerTempDB_Log.ldf';
GO

-- Perform final restore
RESTORE DATABASE ReportServer
WITH RECOVERY
GO

-- Perform final restore
RESTORE DATABASE ReportServerTempDB
WITH RECOVERY
GO