how to Restore a database created in Higher version to a lower version of SQL

Question

Dear All,
I am trying to restore a database create in SQL SERVER 2005 to SQL SERVER 2000.
An error message as "Two many backup device specified"  is appearing at the time
of Restoring the database.

Thanks in Advance

 

---

Regards, Kautily Associate Consultant

Answer 1

HI,

I am not a DBA person but when i am thinking logically first restore the 2005 database file into  the SQL Server 2008 vesion database from there you can generate the script (with data ) and execute it into sql server 2000 version 

for this senario if you want to go head to do and you want any help please reply me i will help you how you can generate the data script.

 

---

" Education is the beginning of transformation. Dedicate yourself to daily learning via Blogs/Forums/books and coaching "
Click here to read my blog

Answer 2

You can not restore database (or attach) created in the upper version into lower version. The only way is to create a script for all objects and use the script to generate database.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 3

HI Kaulity,

It is not possible to Restore database from higher version to lower version of sql, though it can be done by using Script as SUNIL suggested.

 

---

Amit
Please mark as answer if helpful
http://fascinatingsql.wordpress.com/