{"id":286,"date":"2012-06-22T12:30:04","date_gmt":"2012-06-22T19:30:04","guid":{"rendered":"http:\/\/www.sqldbpros.com\/?p=286"},"modified":"2012-07-05T13:58:16","modified_gmt":"2012-07-05T20:58:16","slug":"sql-server-management-studio-recover-lost-files","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2012\/06\/sql-server-management-studio-recover-lost-files\/","title":{"rendered":"SQL Server Management Studio: Recover Lost Files"},"content":{"rendered":"

Nooooooooo!\u00a0 Power outage+unsaved files SQL Server Management Studio files=Panic!!!\u00a0 Wait a sec.\u00a0 Don't panic.\u00a0 Every modern application, especially Microsoft apps, prompts you after a crash and asks you if you want to recover your lost files right?\u00a0 Right!?!\u00a0 Somehow, SSMS does NOT include this feature.\u00a0 Why?\u00a0 No idea.\u00a0 Blame Management Studio's stability.\u00a0 It rarely shutsdown unexpectedly so perhaps this feature was deemed necessary?\u00a0 (Visual Studio on the other hand crashes so regularly I'm guessing the ability to recover files was one of the first features added).<\/p>\n

Don't fear!\u00a0 There is a solution!\u00a0 You can make your dead files come back to life.\u00a0 SSMS does actually save the files it just doesn't prompt if you want to recover them after a crash.\u00a0 Which means you just need to know where to look.\u00a0 There are two possible paths which will reunite you with your zombie files.<\/p>\n

C:\\Documents and Settings\\YourUsername<\/strong>\\My Documents\\SQL Server Management Studio\\Backup Files\\<\/p>\n

Once at this location you should see a solution folder containing the files which were open when SSMS crashed.<\/p>\n

\"\"<\/p>\n

If you find that this path doesn't exist (as one of my coworkers on Windows 7 did) you can try:<\/p>\n

C:\\Users\\YourUsername<\/strong>\\Documents\\SQL Server Management Studio\\Backup Files<\/p>\n

\"\"<\/p>\n

(I'm sure one of you Windows gurus out there can explain that this is actually the same directory being mirrored on a different path because that's what it looks like.)<\/p>\n

So let this be a lesson to you save often because you never know when there will be a power failure (or a zombie apocalypse).<\/p>\n

Thanks to the wizards in the SQLServerCentral Forum<\/a> for originally posting the path!<\/p>\n

\"\"
Zombie files: Yes. Real zombies: No.<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Nooooooooo!\u00a0 Power outage+unsaved files SQL Server Management Studio files=Panic!!!\u00a0 Wait a sec.\u00a0 Don't panic.\u00a0 Every modern application, especially Microsoft apps, prompts you after a crash and asks you if you want to recover your lost files right?\u00a0 Right!?!\u00a0 Somehow, SSMS does NOT include this feature.\u00a0 Why?\u00a0 No idea.\u00a0 Blame Management Studio's stability.\u00a0 It rarely shutsdown […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,43,51,57],"tags":[10,6,9,11,54,5,66,65],"class_list":["post-286","post","type-post","status-publish","format-standard","hentry","category-data-architect","category-microsoft-sql-server","category-sql-server-management-studio","category-t-sql","tag-ms-sql","tag-script","tag-sql-server","tag-sql-server-2008","tag-ssms","tag-tips","tag-walking-dead","tag-zombies"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=286"}],"version-history":[{"count":5,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/286\/revisions"}],"predecessor-version":[{"id":290,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/286\/revisions\/290"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=286"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}