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 |
|
tshin
Starting Member
4 Posts |
 Posted - 2006-12-21 : 15:27:52
|
| 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, |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-21 : 15:39:56
|
| Are you trying to restore over an existing database?Peter LarssonHelsingborg, Sweden |
 |
|
|
tshin
Starting Member
4 Posts |
Posted - 2006-12-21 : 15:42:39
|
| No, I just created a new database. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-21 : 15:45:31
|
| You created a new database with same name as the one you are trying to restore?In my world, that is restoring over an existing database.Peter LarssonHelsingborg, Sweden |
|
|
|
tshin
Starting Member
4 Posts |
Posted - 2006-12-21 : 15:51:19
|
| what I did was.. I created a new databse called 'aaa', and I am trying to restore bbb.bak file into aaa database I just created.Thanks, |
|
|
|
tshin
Starting Member
4 Posts |
Posted - 2006-12-21 : 16:02:43
|
| I got it.Thank you! |
|
|
|
|
|
|
Restore