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

DataAdapter.Update updates zero records

I am having trouble getting an Update call to actually update records. The select statement is a stored procedure which is uses inner joins to link to property tables. The update, insert, and delete commands were generated by Visual Studio and only affect the primary table. So, to provide a simple example, I have a customer table with UID, Name, and LanguageID and a seperate table with LanguageID and LanguageDescription. The stored procedure can be used to populate a datagrid with all results (this works). The stored procedure also populates an edit page with one UID (this works). After the edit is completed, I attempt to update the dataset, which only has one row at this time, which shows that it has been modified. The Update modifies 0 rows and raises no exceptions. Is this because the update, insert, and delete statements do not match up one-to-one with the dataset? If so, what are my choices?I found the source of the problem. It was a result of a conflict elsewhere. So, if anyone else is trying to use a combination of stored procedures and normal sql queries, it will work fine, even if the statements do not match up perfectly with the dataset. The queries simply need to meet any requirements of the database.

Data Transformation Services

When I use the DTS to export data from SQL Server to Oracle 8i, I have no trouble doing it by exporting a whole table. However, if I try to export to Oracle using an SQL query, the table in Oracle gets created, but the table doesn't get populated by the data in my query. I get an ok on the creation of the table, but on transferring of data, I get an error that the table in Oracle doesn't exist. Any ideas? Thanks.Is the creation of the table and pumping of data separate tasks?
If so can you execute them one at a time in the DTS package designer?

I don't know if there is a good way of debugging DTS packages, if anyone knows of it I would appreciate to know how too.