How to delete database on production server
-
How to delete database? Thank you
-
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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
This is possibly the scariest title I've ever read on a forum post.
-
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]
-
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]
-
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 -
Krasavita (10/4/2010)
How to delete database? Thank youSince 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....
-
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 -
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 -
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.
-
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 -
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 -
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) -
Krasavita (10/4/2010)
How to delete database? Thank youhi
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 -
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).
Viewing 15 posts - 1 through 15 (of 37 total)
You must be logged in to reply to this topic. Login to reply