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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy