Attaching a SQL Server 2005 database to SQL Server 2000?
Home > IT Answers > SQL Server > Attaching a SQL Server 2005 database to SQL S...
SQL Server Ask the Experts
2445 pts.
0
Q:
Attaching a SQL Server 2005 database to SQL Server 2000?
SQL Server 2005, SQL Server 2000, SQL Server databases, SQL Server 2005 Database, SQL Server 2000 Database
Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?
ASKED: Apr 14 2009  7:22 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Apr 14 2009  9:54 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0