| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2011-08-02 : 02:14:52
|
| hello everybody,iam unable to restore database,both the source and destination are sql server 2008.the error received is:'backup cannot be restored because it was created by a diffrent version of the server(10.010.4064) than this server(10.00.4000)'Experts please provide a solution for this. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-02 : 02:32:21
|
| the error message is obvious. I think you're trying to restore the backup created on a newer version sql server to machine with lower version sql server. Check your source db and determine if version is same as destination.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-08-02 : 02:35:45
|
[quote]Originally posted by visakh16
the error message is obvious. I think you're trying to restore the backup created on a newer version sql server to machine with lower version sql server. Check your source db and determine if version is same as destination.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/hi visakh,thanks for your quick reply,i have already mentioned the version of source and destination servers.my doubt is how can i upgrade the destination server's version same as the source server's version. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-02 : 05:39:29
|
| The two versions are not the same. The source database for the backup was SQL 2008 R2. The destination is SQL 2008. They are different versions and you cannot downgrade.If you have purchased a licence for SQL 2008 R2 you can upgrade the destination. You do need to check that nothing breaks first. This isn't a service pack, it's a completely different version (like SQL 2005 and SQL 2008)--Gail ShawSQL Server MVP |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-08-02 : 06:11:29
|
[quote]Originally posted by GilaMonster
The two versions are not the same. The source database for the backup was SQL 2008 R2. The destination is SQL 2008. They are different versions and you cannot downgrade.If you have purchased a licence for SQL 2008 R2 you can upgrade the destination. You do need to check that nothing breaks first. This isn't a service pack, it's a completely different version (like SQL 2005 and SQL 2008)--Gail ShawSQL Server MVPthanks a lot for the information... |
|
|
|
mitzanu
Starting Member
2 Posts |
Posted - 2011-08-08 : 07:27:39
|
| I Recommend using a database tool that can easily backup / restore your database, i'm using DbSchema. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-08-22 : 16:33:53
|
| It is impossible to restore a higher version database backup in lower version.go thru the below linkhttp://sqlserverblogforum.blogspot.com/2011/05/restoring-database-from-higher-version.htmlfor all SQL Server versions http://sqlserverbuilds.blogspot.com/I had same issue 10 days ago. I followed below stepsmy dev server is SQL2008R2 and prod server version is SQL2008SP2I was trying to restore R2 backup in SQL2008 sp2 SERVER,but failedBelow are the steps I did. backup file was 2GB size1. create a empty database-same name in SQL Server 2008 SP2 server.2. copy only schema from SQL 2008 R2 version database to SQL 2008SP2 database ( throwing error when I tried to script both schema and data)used Generate scripts option and ran in destination server script for sql server = sql server 2008 sp2type of data to script = schema only.3. Used to import and export wizard to migrate the datasource server- sql 2008 R2destination server- sql server 2008 SP2.got 2 errorserror 1: issue with identity column insertfix: I have identified the table names which has identity columns for those tables i have enabled 'enable identity insert'error2: Got error because import/export wizard does not run the migration based on the dependencies (foreign key).fix: deleted FK's in source database and recreated FK's in destination db after migrating data |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-08-23 : 01:23:44
|
quote:
Originally posted by laddu
It is impossible to restore a higher version database backup in lower version.go thru the below linkhttp://sqlserverblogforum.blogspot.com/2011/05/restoring-database-from-higher-version.htmlfor all SQL Server versions http://sqlserverbuilds.blogspot.com/I had same issue 10 days ago. I followed below stepsmy dev server is SQL2008R2 and prod server version is SQL2008SP2I was trying to restore R2 backup in SQL2008 sp2 SERVER,but failedBelow are the steps I did. backup file was 2GB size1. create a empty database-same name in SQL Server 2008 SP2 server.2. copy only schema from SQL 2008 R2 version database to SQL 2008SP2 database ( throwing error when I tried to script both schema and data)used Generate scripts option and ran in destination server script for sql server = sql server 2008 sp2type of data to script = schema only.3. Used to import and export wizard to migrate the datasource server- sql 2008 R2destination server- sql server 2008 SP2.got 2 errorserror 1: issue with identity column insertfix: I have identified the table names which has identity columns for those tables i have enabled 'enable identity insert'error2: Got error because import/export wizard does not run the migration based on the dependencies (foreign key).fix: deleted FK's in source database and recreated FK's in destination db after migrating data
thanks a lot laddu...for sharing |
|
|
|
|
Database restore issue