Issue
Downgrade SQL 2008 to SQL 2005
Restore from SQL 2008 to prior version.
Product Line
Andover Continuum, TAC INET, TAC Vista
Environment
SQL 2008 used by Building Management Software
Cause
Have database loaded on one machine using SQL 2008 and would like to move or change to SQL 2005
Resolution
Golden Rule: A SQL 2008 database cannot be downgraded or restored to a SQL 2005 version. It is not possible to downgrade a database or a database backup. The SQL schema will not allow it.
For your current version of SQL:
C:\Program Files\Microsoft SQL Server \80, \90, \100 Folders are the client tools.
80 = SQL Server 2000
90 = SQL Server 2005
100 = SQL Server 2008
How ever, it is not a rule. Since 2008 creates both 80, 90. The only way to find what versions are installed (besides regedit) is by the Sql Server Configuration manager.
For other SQL options related to I/NET, please visit SQL and version compatibility for Filemaster, Equalized Client, Remote Client, Limitations of SQL.
