Drop Database

• TomThomson

  SSC Guru

  Points: 104773

  More actions

  February 24, 2015 at 8:36 am

  #1779609

  sipas (2/24/2015)

  ---

  The second answer couldn't have been correct as there's no such thing as an ohysical file - although it must be a common typo as Google gives 107,000 results for it.

  That's interesting. When I search, I only get 11 hits for the string "ohysical file" (only 7 without the "very similar" filter disabled); and if I search for ohysical and file (two words, not necessarily adjacent in that order) I get about 895,000,000 hits.

  the string "[hysical file" gets 105 (or 56) results, so that looks like a more common typo than "ohysical file", but perhaps that's because google treats "[" oddly.

  Tom
  

• sipas

  Hall of Fame

  Points: 3828

  More actions

  February 24, 2015 at 8:49 am

  #1779618

  Oh yeah I forgot the quotes - doh - 14,600 ohysical results (lots of ohysical education, ohysical properties, ohysical therapy...) - quite a few in the URL and some very prominent on the page (e.g. http://quizlet.com/26765501/ohysical-science-flash-cards/). Someone should write a thesis on internet typos and their possible consequences.

• SQLDoubleG

  Hall of Fame

  Points: 3100

  More actions

  February 24, 2015 at 8:58 am

  #1779620

  RK Mandava (2/24/2015)

  ---

  good question,

  here is nice article about that..

  http://www.brentozar.com/archive/2015/02/dropping-offline-database-sql-server/

  +1

  read it too, so this was a piece of cake.

  Nice question!

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  February 25, 2015 at 6:15 pm

  #1780100

  A database can be dropped regardless of its state: offline, read-only, suspect, and so on. To display the current state of a database, use the sys.databases catalog view.

  https://msdn.microsoft.com/en-us/library/ms178613.aspx

  I don't think that the answer selected as correct is right.

  Thanks.

• RK Mandava

  SSCarpal Tunnel

  Points: 4153

  More actions

  February 26, 2015 at 7:45 am

  #1780264

  SQL-DBA-01 (2/25/2015)

  ---

  A database can be dropped regardless of its state: offline, read-only, suspect, and so on. To display the current state of a database, use the sys.databases catalog view.

  https://msdn.microsoft.com/en-us/library/ms178613.aspx

  I don't think that the answer selected as correct is right.

  Answer is right as well as you are also right regardless of the state database will drop but if database or database files are offline, the disk files are not deleted

  in your link general remarks section " If the database or any one of its files is offline when it is dropped, the disk files are not deleted. "

  and

  http://www.brentozar.com/archive/2015/02/dropping-offline-database-sql-server/%5B/url%5D

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  February 26, 2015 at 11:06 am

  #1780342

  Thanks for the question.