January 10, 2013 at 8:10 am
Hi,
i was learning database mirroring in which I created DB1 databse on 2 sqlserver instances on my same pc, but when i try to restore the database it gives me an error:
Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 10.50.2500. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 10.50.2500. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 10, 2013 at 8:15 am
The server where the backup was created is 10.50.2500.0 or SQL Server 2008 R2 SP1, the version you are trying to restore to is 10.00.2531 or SQL Server 2008 SP1.
You'll need to upgrade the SP1 machine first.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2013 at 8:18 am
it exists on my same PC...
Can I create another instance with version 10.50.2500 on same PC ?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 10, 2013 at 8:22 am
You need to sync your patch levels. Applying a service pack on a single machine does not apply it to all instances.
Cheers
January 10, 2013 at 8:35 am
SQL 2008 R2 source, restoring to SQL 2008 destination.
Your essentially downgrading the database which cannot be done.
If you want to restore the database on the destination it needs to be upgraded to SQL 2008 R2, or you will need to use something like SSIS to script out all the data and pump it into the destination
January 10, 2013 at 5:29 pm
To follow on from Anthony, SQL Server 2008 R2 and SQL Server 2008 are not the same version of SQL Server.
SQL Server 2008: 10.0.xxxx
SQL Server 2008 R2: 10.5.xxx
The naming is silly since these are essentially different versions. As mentioned above, you cannot downgrade a database.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply