January 12, 2009 at 1:29 pm
600 mb is not too hard to believe... but 600gb, now that's out there, especially for a single query on a test server?!?!?!
January 12, 2009 at 3:02 pm
Well afraid I can't give you an explanation!
I spotted someone running a query (when he shouldn't have been) and soon as I killed it the free space was there as it should be!
Sorry guys wish I could be more help. Thanks for your thoughts.
January 13, 2009 at 5:57 am
Sorry Sam - have to ask 😛
Was this person running a query against the database you were dropping?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2009 at 7:25 am
Hi David
Wouldn't it give an error if you try to drop a database that is being used by a query?
Regards
Christo
January 13, 2009 at 7:29 am
Yes, that would be the case. Just trying to understand the situation that Sam was seeing. May be one of those unexplained phenomena of the world of technology but I have a curious streak so I thought I would ask more questions. 😀
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2009 at 7:53 am
I have to agree that this is very strange and it would be nice to know how it managed to happen.
January 15, 2009 at 5:39 am
Maybe the query was running off another DB and was growing tempdb and another db like crazy... just another option.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply