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

Database Activity Monitoring. Any tool known tool for Ms SQL Server 2005 or 2000?

Hi all,

Does anyone knows if exists any tool (from microsoft or other vendor) that allows us to monitor all the activity that is generated in SQL server?

I mean Network appliances or servers that monitor database activity and log activity that is external to the database server, and can generate alerts based on unusual behavior or policy violations. Often rely on a local agent to monitor activity.

I am looking for a tool that not searchs on .log files, or creates triggers.

Any suggestion? any known tool? Pls, send me your answers to lc@.quantumsystem.com

Thanks

You can run Profiler externally, put the output into SQL Tables, set Triggers and Alerts to fire from the data.

And the traces can be conformed and customized in just about any way you desire.

|||

Ok, this is not a possible solution.

We are in a bank, so we need to secure our sql. We need no one to cheat the server or the log files (that is why i asked for a non standard sql procedure).

I want some tool from an external provider.

does anyone knows some tool? Remember i dont want tools that reads the log file, or that just add triggers to databases and tables.

We do not want a hardware based solution too...

I hope you can help me.

Regards,

|||

If you don't want to export to a log file... and you don't want to introduce triggers... what options are left?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Paul:

there are some tools (one at least) that runs some monitors (as software services) that allows you to monitor each SQL server, without the option for administrators or DBAs to stop them.

This monitors are connected to central repositories that store all the audited data.

You can audit everything: from select sentences until COPY databases commands, or whatever happens inside the database.

The thing is that i am trying to search , to see if there is another tool, instead the one that we have.

ThankS!