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 |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2014-10-14 : 04:14:51
|
| HiI have a database in sql server 2014 which is in sql server 2008 mode, I try to restore that database on a sql server 2012 but get this error..."System.Data.SqlClient.SqlError: The database was backed up on a server running version 12.00.2000. That version is incompatible with this server, which is running version 11.00.3153. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)"Am I really not able to restore the database? I thought this would be possible since the database is in sql server 2008 mode. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-10-14 : 04:35:26
|
| you are trying to restore a database with higher version to a lower version which is not supported.an alternate would be to generate scripts for all the objects and data and then execute them on the destination server.Javeed Ahmed |
 |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2014-10-14 : 04:50:14
|
| I thought that the fact the database was in 2008 mode this would be possible.... not good..... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-14 : 12:05:40
|
quote:
Originally posted by magmo
I thought that the fact the database was in 2008 mode this would be possible.... not good.....
Compatibility level does not matter for the restore. What matters is the SQL Server version. Restores are not backwards compatible. Typically restores are forward compatible by 2 versions.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2014-10-14 : 12:27:24
|
| This is causing me trouble.... I therefore tried the approach mentioned in this link http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/. I created a virtual machine with sql server 2008 and try to run the script there. When I do that inside sql server manager I get this error "The operation could not be completed. Not enough storage is available to process the command". The script itself is 2.7Gb. Which storage does the error mean? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2014-10-15 : 00:47:54
|
| Hmm, the c: has 20gb free space, isn't that enough for this script? I guess I can do it your approach, but I tend to have issues when using the export import data function (validation issues) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-15 : 12:42:46
|
quote:
Originally posted by magmo
Hmm, the c: has 20gb free space, isn't that enough for this script?
I believe that temp space has a limit set, but I think you can override it. It's been a while since I've looked though. You should research it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
cannot restore backup