SQL 2008 managing 2 Instances on single Physical server

Posted by Rajeev on Server Fault See other posts from Server Fault or by Rajeev
Published on 2011-01-13T13:41:06Z Indexed on 2011/01/13 13:55 UTC
Read the original article Hit count: 269

Filed under:
|
|

Hi, I need some calrification about managing SQL server 2008. The scenario is as follows: I have One Windows Physical server at Primary site, I want to have Two different applications database on it, so shall I create two Instances on same server or shall have diffenrent server for another database. First Database is for management purpose while second would be used for Reporting purpose. There is a second database at the secondary site, which will be in Passive mode and I intend to connect them through MSCS. Now, can I have both Instances on Single server and both will work fine? The management database will be used more. Please reply soon. Can both Instances have dedicated reources allocated to them?

© Server Fault or respective owner

Related posts about server

Related posts about sql-server-2008