database already exists, backup or restore operation terminateing abnornally

Hello,
I am having trouble restoring a MS SQL 7 db. The databse name is
"emloyeedb". The problem started when I tried to cancel the the
restoring process. After I clicked the cancel button, it seemed the
restore process was canceled properly. The I noticed that I could no
longer see the database from the Enterprise Manager.
So I tried to re-create a database with the same name. But I got an
error message said "cannot create file
c:\MSSQL7\data\employeedb_Data.MDF" because it already exists. I went
to that directory and moved the .MDF and .log file into a different
location. Then I was able to re-create a new database called
"employeedb" from Enterprise Manager.
After that, I tried to restored the database from a .bak file. I got
an error message said "database already exists, backup or restore
operation terminateing abnornally".
Can some one tell me why I am getting this error? how to clean up my
db so that I can restore from my .bak file?
Sorry about the lengthy description. Thank you in advance for your
time.
Eddie
Try restore db with replace.
"eddie wang" <eddiekwang@.hotmail.com> wrote in message
news:879e0e64.0409100912.7b647f08@.posting.google.c om...
> Hello,
> I am having trouble restoring a MS SQL 7 db. The databse name is
> "emloyeedb". The problem started when I tried to cancel the the
> restoring process. After I clicked the cancel button, it seemed the
> restore process was canceled properly. The I noticed that I could no
> longer see the database from the Enterprise Manager.
> So I tried to re-create a database with the same name. But I got an
> error message said "cannot create file
> c:\MSSQL7\data\employeedb_Data.MDF" because it already exists. I went
> to that directory and moved the .MDF and .log file into a different
> location. Then I was able to re-create a new database called
> "employeedb" from Enterprise Manager.
> After that, I tried to restored the database from a .bak file. I got
> an error message said "database already exists, backup or restore
> operation terminateing abnornally".
> Can some one tell me why I am getting this error? how to clean up my
> db so that I can restore from my .bak file?
> Sorry about the lengthy description. Thank you in advance for your
> time.
> Eddie

database already exists, backup or restore operation terminateing abnornally

Hello,
I am having trouble restoring a MS SQL 7 db. The databse name is
"emloyeedb". The problem started when I tried to cancel the the
restoring process. After I clicked the cancel button, it seemed the
restore process was canceled properly. The I noticed that I could no
longer see the database from the Enterprise Manager.
So I tried to re-create a database with the same name. But I got an
error message said "cannot create file
c:\MSSQL7\data\employeedb_Data.MDF" because it already exists. I went
to that directory and moved the .MDF and .log file into a different
location. Then I was able to re-create a new database called
"employeedb" from Enterprise Manager.
After that, I tried to restored the database from a .bak file. I got
an error message said "database already exists, backup or restore
operation terminateing abnornally".
Can some one tell me why I am getting this error? how to clean up my
db so that I can restore from my .bak file?
Sorry about the lengthy description. Thank you in advance for your
time.
EddieTry restore db with replace.
"eddie wang" <eddiekwang@.hotmail.com> wrote in message
news:879e0e64.0409100912.7b647f08@.posting.google.com...
> Hello,
> I am having trouble restoring a MS SQL 7 db. The databse name is
> "emloyeedb". The problem started when I tried to cancel the the
> restoring process. After I clicked the cancel button, it seemed the
> restore process was canceled properly. The I noticed that I could no
> longer see the database from the Enterprise Manager.
> So I tried to re-create a database with the same name. But I got an
> error message said "cannot create file
> c:\MSSQL7\data\employeedb_Data.MDF" because it already exists. I went
> to that directory and moved the .MDF and .log file into a different
> location. Then I was able to re-create a new database called
> "employeedb" from Enterprise Manager.
> After that, I tried to restored the database from a .bak file. I got
> an error message said "database already exists, backup or restore
> operation terminateing abnornally".
> Can some one tell me why I am getting this error? how to clean up my
> db so that I can restore from my .bak file?
> Sorry about the lengthy description. Thank you in advance for your
> time.
> Eddie