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 |
|
Cheshire
Starting Member
12 Posts |
 Posted - 2009-01-09 : 17:43:08
|
| I recently had to uninstall our pre-existing copy of SQL Express so it could be moved to another partion. Before doing so I ran a full backup of all the databases found in the SQL Server.Now that I've reinstalled SQL Express (and yes the version numbers match), I cannot figure out how to get the old backed up databases into the new SQL server.Thank you for your attention,-Aaron |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 17:54:06
|
| Restore Database from Backup with RESTORE COMMAND. |
 |
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-09 : 18:22:59
|
| If I right click > task > restoreI just get a message saying access is denied,Or that the database structures dont match so it wont do it.Sorry, if you could be a little bit more specific where this particular restore command is I would be most grateful.Specific Error message:System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'eXpress' database. (Microsoft.SqlServer.Express.Smo)And I've found out that using the 'overwrite' option, whether I leave the file location as C: (the location when the backup was made) or change it to E: (the location where the SQL server is now found), the program I'm running looses track of the database and can no longer find it.Looks like talking to myself really pays off.'restore' wasn't the full answer.'restore' + 'overwrite' + disable services + 'restore as' + 'preserve replication settings'Thanks for being a sounding board regardless. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-10 : 03:13:50
|
| Why are you trying to restore over an existing database? Just restore and specify an new database name and SQL won't complain that the DB you're overwriting doesn't match the one on the backup--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Restoring / rebuilding databases