June 28, 2012 at 5:48 am
I can't believe this! Management Studio has been open all morning, indeed all week near enough. I'd just finished writing a fairly long query (about an hours work), I'd dumped the output to Excel and I was checking through it.
Thought I'd make a tweak to the code and Management Studio had disappeared, no crash, no asking me if I wanted to close - just disappeared. (Outlook, Firefox and Excel were the only other windows open, I'm not disorganised with 300 windows open)
If I open it again no prompt for a recovery and if I look in the usual locations for temp files from recovery there's nothing.
Does anyone know where I'd see what's going on in this regard in the Event Log (in Windows, not sql) as it's not the first time this has happened.
Any help much appreciated, I don't know what would cause this and whether it could randomly happen whilst I'm using Management Studio.
Cheers!
June 28, 2012 at 5:53 am
Rob to help alleviate some of that headache in the future, grab the SSIS addin here:
one of the things it has is that it automatically keeps a history of every SQL you execute in SSMS. That can really help you recover the last thing you were working on in that kind of situation.
This saved my tailonce, and I was able to go to the SQL seach history and grab copies of some work i had tested but accidentally closed the window without saving.
Lowell
June 28, 2012 at 5:57 am
Lowell, that's great, I'll look into that.
Do you happen to know if there's an event log dedicated just to Management Studio? I couldn't see one, I wanted to see what it claimed had happened around 12:15 :/
June 28, 2012 at 6:07 am
not that i'm aware of as far as the log being more dedicated to SSMS.
did you manually look in the backup folder?
C:\Users\yourusername\Documents\SQL Server Management Studio\Backup Files\Solution1
and see if anything was still there?
Lowell
June 28, 2012 at 6:20 am
yeah I took a look, it's actually in a different location because I'm on Windows 7 : http://aalamrangi.wordpress.com/2011/10/25/recover-queries-after-a-sql-server-management-studio-ssms-crash/
I looked at my original post all those years ago!
http://www.sqlservercentral.com/Forums/Topic500268-149-1.aspx
On the plus side, I was able to type super quick and throw down some dirty code to prove the code I'd lost had delivered the correct results rows wise so that's some progress.
That addon looks quite nice, is it obtrusive in anyway? Whilst it may give me loads of benefits I'd be looking for the logging you mention first off without it interfering with other stuff unless I let it. Is it like that or does it take over MS?
June 28, 2012 at 7:38 am
Rob to help alleviate some of that headache in the future, grab the SSIS addin here:
http://www.ssmstoolspack.com/%5B/quote%5D
+1
That has saved me more than once!
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 7:57 am
Right, I've got that tool installed, I've disabled everything except the history, and got rid of the toolbar, it seems to be doing it's job without getting in the way. I didn't like all the templates and that jazz 😮
Thanks for the suggestion, I'm sure it will prove very useful!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply