SQL 2008 managing 2 Instances on single Physical server
- by Rajeev
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?