October 25, 2016 at 8:04 am
I am in the process of spec-ing out our consolidation and upgrade from 2008 to 2014. I would like to use the open readable database option on the secondary replica for reporting. But I would also like to put other separate read/write databases on that same instance. Is that possible?
ex:
Report_Server
Prod_DB (Read only - replicated from production_server over availability groups)
rept_db (read/write - only exists on this server)
modality_report (read/write - only exists on this server)
SSRS_Summary (read/write - only exists on this server)
October 25, 2016 at 8:13 am
Derek Knutsen (10/25/2016)
But I would also like to put other separate read/write databases on that same instance. Is that possible?ex:
Report_Server
Prod_DB (Read only - replicated from production_server over availability groups)
rept_db (read/write - only exists on this server)
modality_report (read/write - only exists on this server)
SSRS_Summary (read/write - only exists on this server)
Of course it's possible. You have to watch the HW resources to not overload the server.
Igor Micev,My blog: www.igormicev.com
October 25, 2016 at 8:30 am
Ok - I just wanted to make sure that the availability group configuration would not impede putting other databases on the same instance.
Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply