[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

MS SQL 2008 Server

Is it possible to run MS SQL 2008 Server with MS SQL 2008 R2 on the same server?

We have an .NET app that is only compatible with MS SQL 2008 R2 and our customer has an app on the same server on MS SQL 2008 and does not want to upgrade the current app until our .NET app is installed and tested.
0
Gerhardpet
Asked:
Gerhardpet
2 Solutions
 
BlueYonderCommented:
You are able run both 2008 and 2008R2 side by side.  You will need to install 2008 R2 as a named instance.  The MSDN, articlehttp://msdn.microsoft.com/en-us/library/ms143694(v=sql.105).aspx,  indicates it is possible. Make sure you read this article, http://msdn.microsoft.com/en-us/library/ee210714(v=sql.105).aspx, before you decide to have both running at the same time.
0
 
Ramesh Babu VavillaCommented:
yes you can run  2 different instanaces with version differences in sql server. you can you resource governor to limit and share the CPU of the Server with different version instances installed
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Yes.  Please make sure to correctly provision IO, CPU and RAM resources so that each instance does not step over the other instance resources.  For instance, please make sure to limit the maximum amount of RAM allocated to each instance.

Hope this helps.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now