<div>
<div class="content wysiwyg-content">
Hi All<br />
I need to migrate a sql server db from 2008 to sql express. When I try to restore it via management studio I get the following error. Is there a simple massage of this sql file, or if not. please advise correct procedure.<br />
thanks<br />
<br />
System.Data.SqlClient.SqlE<wbr />rror: The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoEx<wbr />tended)
</div>
</div>


Hi All
I need to migrate a sql server db from 2008 to sql express. When I try to restore it via management studio I get the following error. Is there a simple massage of this sql file, or if not. please advise correct procedure.
thanks

System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

SQL SERVER RESTORE OLD BACKUP VERSIONS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.