Tuesday, May 8, 2012

SQL Server Management Studio crashed!

Submit this story to DotNetKicks

Hi everybody,

Ever experienced having SQL Server Management Studio crash on you after a long day of coding and when you start it up again it doesn't offer you to recover the files you were working on? Well that just happened today and I was a bit worried when I wasn't offered with a recovery. So I googled a bit and found this handy solution: http://www.sqlservercentral.com/Forums/Topic500268-149-1.aspx

In short you can go to your document folder, enter the "SQL Server Management Studio" folder and enter "Backup Files". There should be a folder called "Solution1" and in that folder you should find all your lost work.

Now...back to work.

1 comment:

stealthbits said...

Hello Friends,

If the SQL Server Management Studio (SSMS) crashes for any reason before you could save your work, usually, the next time you start SSMS, it shows a dialog box as below to ask you if you’d like to recover the queries. But sometimes it may not ask for recovery and it might seem that all the work is lost. Well, most of them can still be recovered because the recovery dialog shows where are the backup files located. This is a very good process through which one can recover data easily. Thanks a lot....
Server Audit Tool