mistakenly deleted 1

[btacy]

i was trying to delete one of my test databases and mistakenly deleted the production, or rather clicked delete on the production db. i realized my mistake almost immediately, but could not stop the action, luckily people were logged on and i had not selected the option to close all connections and so it failed.
later, i noticed some disparity in some data and i'm not sure if the problem was caused by my mistake or not.

Does anyone have an idea how the delete works? does it start from tables without user connections on them or does it scan the entire database first before deleting it?

 

[SQLDenis]

Lookup DROP DATABASE in BOL, that's what happen when you mousy..mousy..click..click in Enterprise Manager

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[gmmastros]

Step 1: Beg your DBA to remove those priveleges from your account.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[AlexCuse]

Step2: visit forum654 for advice on how to spin this on your resume.

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[tperri]

lmao Alex

 

[LNBruno]

Step 3: Update resume?

< M!ke >
[small]Where are we going and why am I in this handbasket?[/small]

 

[gbaughma]

That is what is known, in this business, as an "Onosecond".

That's the moment between when you clicked the mouse, and realized what you did, and said OH NO!!!!



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[ptheriault]

You should also never put your test databases on the same server and or instance as your prod db too. The list of things that could go wrong is very long. (and it includes your attempt to drop the prod db by mistake!)

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[damber]

you're lucky that you boss didn't order for you to be 'mistakenly deleted' too...




A smile is worth a thousand kind words. So smile, it's easy!