February 24, 2015 at 7:51 am
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.
February 24, 2015 at 8:36 am
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
February 24, 2015 at 8:49 am
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.
February 24, 2015 at 8:58 am
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!
February 25, 2015 at 6:15 pm
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.
February 26, 2015 at 7:45 am
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/[/url]
February 26, 2015 at 11:06 am
Thanks for the question.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply