By
Published: 11 Sep 2007
Can you install two different versions of SQL Server on the same box?
Yes you can. While you theoretically can install them in either order, I'd always suggest installing the software in the order it was released: SQL Server 2000 first, then SQL Server 2005.
Check out this helpful tip: |
|
- Compatibility of SQL Server 2005 and 2000 coexisting
So, you've decided to upgrade your databases to SQL Server 2005. Database expert Michelle Gutzait highlights some issues that may arise when installing a SQL Server 2005 instance on your SQL Server 2000 machine. Also discussed are options for interaction between the two versions, such as: linked servers, multi-server administration and log shipping.
|
Dig Deeper on Microsoft SQL Server Installation
Related Q&A from Greg Low
Find how to query in SQL Server to get all database names created by users.
Continue Reading
Triggers in SQL Server can be executed before a table is updated. Get triggers to read and extract table values before and after the table is updated.
Continue Reading
Find out why problems calling an extended stored procedure in SQL Server 2005 can involve security settings.
Continue Reading