drop production database

Question

drop production database

vsm198

Old Hand

Points: 340
More actions
June 25, 2010 at 8:05 am

#387217

Hi Gurus
I am new SQL server DBA.
I have a request to drop production database. Kindly advice what should be done before droping a production database.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Find out why it's been dropped and make sure that the person asking is correct in asking for it to be dropped.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

vsm198 Old Hand Points: 340 More actions · Answer 2

yes, I have approval to drop the database. What should be done before droping a database.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Make sure you take a full backup of the database prior to dropping it, just in case someone comes back and needs it.

Lowell SSC Guru Points: 323518 More actions · Answer 4

i'd think it through first...what happens if the database goes missing? does the company shut down? is the database being used? maybe they mean they want you to move the database to another server, or restore it from a previous version?

ask the person who told you to drop the database if that means it should not be used anymore?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 5

I would just take it offline and then see if anyone screams. If no one does after about a month, then drop it.

But absolutely take a full backup just before taking it offline.

Andrew SQLDBA

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 6

AndrewSQLDBA (6/25/2010)
I would just take it offline and then see if anyone screams. If no one does after about a month, then drop it...

I would just turn off power on the server unit. And if no one screams, you can start reusing it for something more usefull than for holding unwanted databases...

:-D:-D:-D

Also, you may find that cutting off power of the whole building (at least for the month), may safe a lot of company money in electricity bills... You even might be paid bonus for finding new way to safe money...:hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 7

vsm198 (6/25/2010)
yes, I have approval to drop the database.

Did you get it in writting?

Does the organization uses a ticketing system? in the affirmative case ask for a fully approved change management ticket 😉

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 8

I'd do as Andrew suggested. Make a backup, archive it, then drop it. If you are really concerned, you can script out any logins that make use of this database (check mapped users) and save that as well.

Lowell SSC Guru Points: 323518 More actions · Answer 9

this kind of request ranks up there with a request that was once heard at Enron:

Run everything in these filing cabinets through the shredder...boss said it was ok, and those are his orders.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 10

Lowell (6/25/2010)
this kind of request ranks up there with a request that was once heard at Enron:
Run everything in these filing cabinets through the shredder...boss said it was ok, and those are his orders.

😀

CEO is staying around the shreadder trying to figure out how to use it...

He asks the young clerk for a help. Boy puts the banch of paper into the shreadder, turns power on and presses GO button.

Clerk: - All done!

CEO: - Thank you very much for your help. I have a board meeting starting in 5 minutes and I need five copies of this anual report...

:w00t::hehe::w00t:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]