• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

SQL Server 2008 DB convert to 2005 DB

Hello,

I have a database that is compatible with SQL server 2008, how can I restore it over a SQL server 2005 database?
0
Matthew34
Asked:
Matthew34
2 Solutions
 
dsackerContract ERP Admin/ConsultantCommented:
Databases are upward compatible, not downward compatible. You can try the following link, but your chances of success are next to nil, and your effort will be substantial.

http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx
0
 
COANetworkCommented:
If you have both a 2008 and a 2005 system up at the same time, you can try to DTS data and objects from one DB to another.  It will be longer than a restore, and not every object can be transferred, though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now