September 7, 2015 at 10:41 pm
Hello,
I am currently looking into migrating RS from 2005 into 2014, and was curious to know if there was anything specific that has to be done to configure SSRS to continue working, once it has been placed into an AG and gone through a failover. I'm not up to the AG group part yet, but I'm just trying to get ahead of the curve in case there is anything specific I'd need to look into or configure in advance of the migration.
Any advice in achieving this would be gratefully appreciated.
Thank you.
Regards,
D.
September 8, 2015 at 4:00 am
Duran (9/7/2015)
Hello,I am currently looking into migrating RS from 2005 into 2014, and was curious to know if there was anything specific that has to be done to configure SSRS to continue working, once it has been placed into an AG and gone through a failover. I'm not up to the AG group part yet, but I'm just trying to get ahead of the curve in case there is anything specific I'd need to look into or configure in advance of the migration.
Any advice in achieving this would be gratefully appreciated.
Thank you.
Regards,
D.
Are you saying you want to store the Reportserver database in an Availability Group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2015 at 1:33 am
Hi Perry, yes that's right. Your reply makes me think its impossible, or totally easy and I'm stupid for asking! 🙂
After failover, Id like the reports to continue working, I'm wondering if I need to maintain two reporting services instances for that to happen.
Regards,
D.
September 16, 2015 at 5:29 am
well initially for the reportserver database I'd say yes but the reportservertempdb, no. You only want to provide resilience for this database so putting it on a clustered instance of sql server will provide that.
For a busy report system the amount of mirror traffic that could be generated may cause issues
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply