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.
Tuesday, May 8, 2012
SQL Server Management Studio crashed!
Subscribe to:
Post Comments (Atom)
1 comment:
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
Post a Comment