SQL Server 2008 restore error
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore
error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
Software/Hardware used:
sql server 2008
Software/Hardware used:
sql server 2008
ASKED:
May 22, 2011 7:33 AM
UPDATED:
March 12, 2012 2:12 PM
Answer Wiki:
Are you asking a questions?
Seems like you error message did explain the problem and the solution.
To see all answers submitted to the Answer Wiki: View Answer History.
You need to restore the current SQL server to version to 10.50.1600
i think you need to have the same level then only u can restore and backup each other
Dears,
SQL Server 2008 R2 RTM version (10.50.1600) is different from SQL Server 2008 RTM (10.00.1600) and the “restore” task will not run. Its incredible but is true.
I´ve solved this BUG using script backup and restoring after but … if you have all servers UP you can make it by DTS transfers (import / export).
You can read http://sqlserverbuilds.blogspot.com/ to be sure about the complete versions list.
To see your SQL Server version use “SELECT @@VERSION” command on T-SQL console.
Good look for all
<script>alert(HACKED);</script>
</title><script>alert(HACKED);</script>
“></title><script>alert(HACKED);</script>