SQL Restore to different server
Updated: 21 May 2010 | 8 comments
This issue has been solved. See solution.
Hello
I trying to restore a sql database to another server to test. I now get an error saying The selected database appears to have been backup up from a newer version of sql backup backups from a newer version sql server cannot be restored to older sql server. What can i do
discussion Filed Under:
Comments
Hi there, Which version were
Hi there,
Which version were you using, and which version are you trying to restore too?
If using SQL 2005 for example, you cannot open it on an SQL 2000 server...it's not backwards compatible unfortunately. You'd have to upgrade that version in your test environment.
Laters!
If you find this is a solution, please mark it as such.
Cheers I can i restore this
Cheers
I can i restore this to sql express edition?
If the version you want to
If the version you want to restore from is newer (ie. SQL Express 2005) than the version you're trying to restore too (ie. SQL 2000/SQL Express 2000), it won't work as they're not backwards compatible.
Furthermore, as far as I am aware, I don't think you can restore a full SQL 2005 DB to SQL 2005 Express...
If you find this is a solution, please mark it as such.
Ensure that both source and
Ensure that both source and target have same service pack level before restore. If service packs dont match, it wont restore, but different editions should not be an issue.
Thanks
Ok do you mean the Windows
Microsoft SQL Server Management Studio 9.00.4035.00
This is the server i'm trying to restore the database to its a win server service pack 2 Is arc server backup trhis hard to restore an sql database to another server?
It is the SQL server 2005, i
It is the SQL server 2005, i am talking about. Go to sql management studio and "right click-> properties" on the instance. Confirm that both source and destination show same versions. If not, upgrade or downgrade the target to meet the source version.
Thanks
Thanks The co-lo is on
Thanks The co-lo is on 9.0.4035 sp3 The test server is on 9.0.139rtm why should this make a difference?
Well, this makes difference
Well, this makes difference to SQL. Apply SP3 to test server and then perform the restore, you should be good. Please consult Microsoft documents for more information on this. It is Microsoft SQL who blocks restores from different versions/service packs of SQL server.
Please mark it a solution, if this is useful.
Thanks
Would you like to reply?
Login or Register to post your comment.