We are setting up a new SharePoint 2010 QA server and would like to use the same SQL server as our SharePoint 2007 QA server. Are there any issues or gotchas with this strategy?


That should work just fine. You don't need separate SQL instances either, just make sure you don't do the 'all in one, let the SharePoint installer sort everything out' install.

This is assuming that your SP2010 and SP2007 servers are 2 separate (virtual) servers talking to the same SQL database server.

  • Thanks, do you know if content deployment would be effected in this model? Where QA 2007 deploys to prod 2007 and now I want to start creating 2010 DBs in the same SQL instance as QA 2007. – jjr2527 Feb 16 '11 at 21:19
  • Yes, the front end and app servers are separate from the SQL host. – jjr2527 Feb 16 '11 at 21:22
  • I don't anticipate any interference between the 2. – Jeroen Ritmeijer - Muhimbi Feb 17 '11 at 7:52

There shouldn't be a problem as long as you use separate SQL instances for 2007 and 2010 on the same server. They will operate independent of each other so no problems should arise.

  • 1
    No need for 2 different SQL Instances. We host 10 SharePoint instances (2007 and 2010) on the same SQL Server Instance just fine. – Jeroen Ritmeijer - Muhimbi Feb 16 '11 at 18:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.