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?
Asked
Active
Viewed 706 times
2 Answers
1
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.
atrljoe
- 201
- 3
- 9
-
1No need for 2 different SQL Instances. We host 10 SharePoint instances (2007 and 2010) on the same SQL Server Instance just fine. – Jeroen Ritmeijer Feb 16 '11 at 18:01
1
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.
Jeroen Ritmeijer
- 4,897
- 1
- 23
- 33
-
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
-
-