SQL Database Backup Error: Version is incompatible with this server. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Question

hi my server sqlserver is 2008R2 and my pcs sql is 2008 when I want restore bakeupin sql server2008 this error happenADDITIONAL INFORMATIONSystemDataSqlClientSqlError The database was backed up on a server running version 10501617 That version is incompatible with this server which is running version 10001600 Either restore the database on a server that supports the backup or use a backup that is compatible with this server MicrosoftSqlServerSmo

Azim · Accepted Answer

SQL Server is not backwards compatible and henceRight click on your SQL Database Click on TaskSelect Generate ScriptThen a wizard control will comeIt will ask you some Question Like Database selectionLike what you want to include in Script Table Stored Procedure User Defined functionTable SelectionWhere you want to generate the scriptIn the end your Script will be generatedNow you can execute this Script in SQL 2008 So you Database will be created But there will not be any Data available in the tableReferHow to generate script file of complete database in SQL Server How to make a database generate script in SQL Server 2005

SQL Database Backup Error: Version is incompatible with this server. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Company

Explore

Follow us

Contact Us