question

bk-4602 avatar image
0 Votes"
bk-4602 asked Joyzhao-MSFT commented

Migrate Report server db

Hi All,
We have a a report server db on SQL Server and we are decommissioning the server. What all changes need to be made SSRS wise? Please advice.
Thanks

sql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @bk-4602 ,
Has your issue been resolved?
If you have any questions,please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Regards,
Joy

0 Votes 0 ·
DavidBrowne-msft avatar image
0 Votes"
DavidBrowne-msft answered

Read the documentation and follow the instructions: Migrate a Reporting Services Installation (Native Mode)


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @bk-4602 ,
Methods of moving the database, including backup and restore, attach and detach, and copy. Not all methods are suitable for relocating an existing database to a new server instance. Depending on your system availability requirements, the method of moving the report server database will be different. The easiest way to move the report server database is to attach and detach the database. However, this method requires that you take the report server offline while detaching the database. If you want to minimize service interruption, backup and restore are the best options, but you must run Transact-SQL commands to perform the operations. It is recommended not to copy the database (especially not to use the Copy Database Wizard); doing so will not preserve the permission settings in the database.

Please refer to: Migrate a Reporting Services Installation (Native Mode)
Note: Be sure to back up the encryption key
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.