Home > IT Answers > SQL Server > Attaching a SQL Server 2005 database to SQL Server 2000?
SQL Server Ask the Experts
2,585 pts.
 Attaching a SQL Server 2005 database to SQL Server 2000?
SQL Server 2000, SQL Server 2000 Database, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?

Software/Hardware used:
ASKED: April 14, 2009  7:22 PM
UPDATED: April 14, 2009  9:54 PM
RELATED QUESTIONS
Answer Wiki:
No there is no way to attach a database that was created in SQL Server 2005 to SQL Server 2000. You can only go up, you can not go backwards. To move a database down a version, you have to script out the objects and then export the data, or use the database transfer wizard.
Last Wiki Answer Submitted:  April 14, 2009  9:54 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _