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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-22 : 07:48:50
|
| tshin writes "I have a question.I am trying to restore .bak file, that was created on MS Sql 2000 server, to MS SQL 2005 Express running on my laptop.Is it possible to do that?because when I tried to do it I got an error message saying "System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'AAA' database. (Microsoft.SqlServer.Express.Smo)Please help me out.Thanks," |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-22 : 11:28:10
|
| Yes you can restore from 2000 to 2005 Express. You probably need to select the replace option in the restore command or restore GUI.Tara Kizer |
 |
|
|
|
|
|
Restore