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 |
|
eashoori
Starting Member
22 Posts |
 Posted - 2007-10-01 : 09:38:39
|
| I have a database, I just received a fresh copy of it, I created a new database in enterprise 2000 in order to restore the fresh copy on it but it gives me the following error:You are attempting to overwrite an existing database, check the force restopre over existing database option to overwrite the existing database.how can I fix it? Shall I even forgo the new database and just restore the fresh copy on the already originall database or is there a way that I can restore it on the new database? Thanks for any info |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-01 : 11:14:00
|
How are you doing the restore? Just specify a different database name then the existing database when you are doing the restore.
Future guru in the making. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
eashoori
Starting Member
22 Posts |
Posted - 2007-10-01 : 12:29:57
|
| Thanks, I know I can always depend on your quick and witty replies. I made a back up on the old original copy, then restored it but used the fresh copy file, that should work, wouldn't it? Now I am trying to query and see if there are any updated field and compare it |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-01 : 22:47:21
|
| Or use 'with replace' option in restore statement. The reason you got this message is that source db name is different from target db name. |
|
|
|
|
|
|
|
|
Fresh copy of existing database, how can I restore
See: