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
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
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
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.
Read the documentation and follow the instructions: Migrate a Reporting Services Installation (Native Mode)
6 people are following this question.