Home > IT Answers > SQL Server > Restoring a SQL Server 2005 IBM Rational Requ...

Question

Asked: Mar 6 2008 10:47 PM GMT
Asked by: SQL Server Ask the Experts

Restoring a SQL Server 2005 IBM Rational RequisitePro database from SQL Server 2008, back to SQL Server 2005

I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.

Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER

View History

RATE THIS ANSWER

0
Click to Vote:

Last Answered: Mar 7 2008 2:11 AM GMT by Mrdenny

You can not backup a database and restore it to a prior version of SQL Server. You'll need to script out the objects and then copy the data from the SQL 2008 database to the SQL 2005 database.