Higher to Lower version restoration!

Can we restore the database of Higher to Lower version restoration?
OK let's Plan like this -Backup the database of SQL server 2008(before backing up change the Database compatible level to 90) then restore the database on SQL server 2005.

Backup completed of SQL server 2008 database after changing 100 to 90.

Now I will go for the restoring the database on SQL server 2005 -let's see what it throws an error even though changed the compatibility of the database-

 

 So I plan to see what the Header of the Backup file to get some information about Backup file, how ever it is failed to reterive data in SQL server 2005 & it throws sam error-

 So one way we can do, not restore method but we can use script out method so,Let's see how it is.
*Log in to the SQL server 2008 ->select the database( which you want place in sql server 2005) ->Right click Tasks ->Generate the scripts and change the script for server version to your comfortable version.

Please see the below figures:-

                                          

Now I will use the above scripts and will execute in the new query window of SQL server 2005 -

(see the figure below)  before that I have created an dummy database called :DBMAINT_TEST

after executing the script you will get the outpuy as Command's completed successfully........(please see fig)

Finally it's done

Bottom Lines

---------------

1.You cannot restore the database from Higher to Lower version.

2You can also use -Import and export wizard instead of Generate SQL Server Scripts Wizard. This solution exports data to the targeted SQL Server using a wizard. It is more secure and effective than the first solution. But you can only export tables and views only.

3.Note ->When you restore or attach a database which is created from SQL Server 2008 to SQL Server 2005 or SQL Server 2000, you will get an error so other way you can use is the Bottomline 2 options.

Thank you!!!