Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dennis_QSG
Starting Member
3 Posts |
 Posted - 2010-07-26 : 07:09:20
|
| Hi everyone,first of all sorry if my english isnt correct all the time, im from germany.My Problem:In my Company for our latest customer we use a MS SQL Server 2008 Workgroup Edition and in the Company itself on the virtual Machine were we work and develop the Database furhter on, we use a SQL Server 2008 Express edition.We did that for over a couple of years with the 2005 versions in the same manner.But with 2008 i got the problem that when i tried to restore the Customer Database with the Database from our virtual machine i got an error that said that this version isnt compatible with this server.Is this just an update issue on the Workgroup Edition or is there no chance to get this backup running on the customer-server?Right at the moment i try to reproduce it in the company, so i can provide u with the original error-message.Any information or suggestions are welcome.Update: Error TextSystem.Data.SqlClient.SqlError: Die Datenbank wurde auf einem Server der Version 10.50.1600 gesichert. Diese Version ist mit diesem Server inkompatibel, da auf ihm die Version 10.00.2531 ausgeführt wird. Stellen Sie die Datenbank auf einem Server wieder her, der die Sicherung unterstützt, oder verwenden Sie eine mit diesem Server kompatible Sicherung. (Microsoft.SqlServer.Smo)Translation: The backup of the database was on a Server running Version 10.50.1600. This Version is incompatible because the Version here is 10.00.2531. Backup the Database on a Server which is providing this type or use a backup which is compatible with this server. ThanksDennis |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-26 : 08:32:17
|
| 10.5 is SQL 2008 R210.00 is SQL 2008I think that is your problemDescription of versions here:http://www.sqlteam.com/article/sql-server-versions |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-07-26 : 08:45:08
|
With 2005 there is only 1 single database version. But for 2008, the version is different from 2008 R2 as what Kristen has highlighted. Basically you can't restore SQL 2008 R2 database into a SQL 2008 Server.Since you are using Express edition, you can get the 2008R2 express from http://www.microsoft.com/express/database/
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Dennis_QSG
Starting Member
3 Posts |
Posted - 2010-07-26 : 09:18:15
|
| Ok thanks for your Information.I think i solved it with SQL Compare, but need to do some further checking if the applications work with it (i just needed some new tables and about 200 entries/changes in tables).Can someone of u tell me in short and simple Words whats the difference between a Workgroup edition and R2, i am a little in trouble with this.Thanks Dennis |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-26 : 09:23:56
|
| SQL2008 R2 should have been called SQL 2010, or SQL 2008.5Its a minor upgrade, but is not backwards compatibility with SQL 2008I think the "R2" name is really stupid, and confusing |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-07-26 : 10:07:07
|
SQL Server R2 is the latest version of SQL Server. Workgroup is an Edition. A version will consists of several edition like Enterprise, Standard, Developer, Workgroup, Express etcfor details on edition comparison seehttp://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Dennis_QSG
Starting Member
3 Posts |
Posted - 2010-07-26 : 10:17:20
|
| Ok thanks for the Information from everyone.Regards,Dennis |
|
|
|
|
|
|
|
|
Database incompabilities