How to delete database on production server

Question

How to delete database on production server

Krasavita

SSC-Insane

Points: 23138
More actions
October 4, 2010 at 2:50 pm

#224707

How to delete database? Thank you

Viewing 15 posts - 1 through 15 (of 36 total)

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

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

Open management studio, connect to server. Right click database, select delete. Check that you deleted the correct one.

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

Derrick Smith SSChampion Points: 10833 More actions · Answer 2

This is possibly the scariest title I've ever read on a forum post.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

I recommend you take a look at this link

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

Derrick Smith (10/4/2010)
This is possibly the scariest title I've ever read on a forum post.

Scary in more ways than 1.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Why drop the database?

You could also run

Drop database [MydatabaseNameGoesHere]

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

LutzM SSC Guru Points: 107049 More actions · Answer 6

Krasavita (10/4/2010)
How to delete database? Thank you

Since it's a production server and it seems like you don't know how to do it and -much more important- what to do BEFORE you delete (drop) a production database: DON'T TOUCH IT!!!

Get a senior DBA and describe what you want to do.

A 2 inch bullet proof glass shield between you and the DBA while asking most probably will be a healthy decision 😉

If you're the senior DBA: replace "DBA" with "consultant" and re-read the paragraph above.

Side note: I'm scared....

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 7

Hopefully, this was an interview question.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

One thing that I didn't see asked was if this was to drop the database, or to delete data from within the database.

Krasavita - could you expound a bit?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you can recover it later if needed.

WayneS SSC Guru Points: 95460 More actions · Answer 10

Lynn Pettis (10/4/2010)
As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you can recover it later if needed.

Or, you could always use DBCC TimeWarp!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

WayneS (10/4/2010)
Lynn Pettis (10/4/2010)
As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you can recover it later if needed.
Or, you could always use DBCC TimeWarp!

Somebody really should write a full fledged article on that procedure.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 12

Soembody really should start a thread on the questions we sometimes have to answer. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 13

Krasavita (10/4/2010)
How to delete database? Thank you

hi

Krasavita

Krasavita, Just I want to what is in your mind, are you really want to delete the Database?

Just Fallow the Gail Shaw comment, and others also. and its recmonded take a backup before dropping the data base.

Ali
MCTS SQL Server2k8

SteveBell SSCrazy Points: 2008 More actions · Answer 14

CirquedeSQLeil (10/4/2010)
WayneS (10/4/2010)
Lynn Pettis (10/4/2010)
As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you can recover it later if needed.
Or, you could always use DBCC TimeWarp!
Somebody really should write a full fledged article on that procedure.

Thanks for the reference. I've read the thread and now understand that the universe is unfolding as it should. Cirque, we will write a full-fledged article (I see it in my backup of July 10 2012).