I have come in today to find my PC rebooted, I suspect due to windows updates, (it decides to reboot with no warning sometimes I swear)
Anyhow, I left management studio open with about 6 queries on the go, some of which were not saved, on the whole its no biggy today, as the important ones were saved, but it does mean some extra work to get back to where I was, kinda annoying.
Is there no auto save / auto recover facility - I just opened Mgnt studio and it just opened as usual, no 'recover files' prompt or anything - I looked in the options for ages and didn't find anything, I also looked on the books online, again nothing. I googled for it and found someone who had recovered documents...
And, here's the coolest part, I was working on some SQL files at the exact time of the disaster and well, I went to the \Documents and Settings\username\My Documents\SQL Server Management Studio\Backup Files\ directory and found a directory of Solution1. In it were 3 files with similarly ugly names (~AutoRecover.~vsC.sql, ~AutoRecover.~vsC.sql~RF93d469.TMP, etc...) and the AutoRecover file was 2KB (the others were 0KB). Anyway, I opened up the file and viola! I actually recovered the .sql script I was working on at the time I dropped my laptop (well, I still blame this on Paul cause he made me lean over to talk to him and this ultimately pushed my laptop off the crappy airline table 😉 😉 😉 :).
So I guess it must be possible, I just can't find the options anywhere, and I don't have the directory she mentions either :/
(Taken from this page: http://www.sqlskills.com/blogs/kimberly/2008/05/09/WhenDidYouLastBackupYourHomepersonallesscriticalSystemIsItReallyLesscritical.aspx )