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 |
|
J Trahair
Starting Member
15 Posts |
 Posted - 2011-03-30 : 13:26:58
|
| I have SQL Server 2005, installed about 4 years ago, on Windows XP. I have a backup from a SQL Server 2005 installed today from MS download site onto Windows 7 Home Premium 64bit laptop.A backup from one version will not restore onto the other, although I can backup and restore with a third computer running SQL Server 2005 installed about 4-6 weeks ago.Error message when I try to restore from the W7 64bit to my XP 32 bit Restore failed for Server 'HPLAPTOP\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'Customer_database' database. (Microsoft.SqlServer.Express.Smo)Of course, 'Customer_database' does exist and I can backup and restore it onto and off my XP laptop, and the Win7 64bit can do the same, but not one to the other.What reason(s) might there be? Thank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
J Trahair
Starting Member
15 Posts |
Posted - 2011-03-31 : 03:33:04
|
| Thanks, that did it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Can't restore from another SQL Server 2005