If you are trying to restore database backup of SQL Server 2008 R2 to SQL Server 2008 or 2005, you are bound to fail. Database backup of SQL Server 2008 R2 is not compatible backward, you cannot restore it to SQL Server 2008. The following is a solution to convert databases of SQL Server 2008 R2 to 2008.
(2) Click ‘Next’.
(3) Choose objects that you want to script, then click ‘Next’.
(4) Click ‘Advanced’ and set the (Script for Server Version) property to the version that you want as it shown in figure number 5. Then click ‘Next’ to get the script
(5) Set options.
Now you got a complete database creation script with data. It can be executed on target database server.