Blog

SQL Server Management Studio: Recover Lost Files

Banner will redirect to landing page with Certification Track courses.

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

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

C:\Documents and Settings\YourUsername\My Documents\SQL Server Management Studio\Backup Files\

Once at this location you should see a solution folder containing the files which were open when SSMS crashed.

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

C:\Users\YourUsername\Documents\SQL Server Management Studio\Backup Files

(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.)

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).

Thanks to the wizards in the SQLServerCentral Forum for originally posting the path!

Zombie files: Yes. Real zombies: No.

Tags: , , , , , , ,

6 Responses to “SQL Server Management Studio: Recover Lost Files”

  1. Vikram October 4, 2012 at 8:44 am #

    Thanks a lot.. you saved my 10 hours worth work which I would have lost because of sudden power outage. Lesson learned save your work as much as you can.
    Thanks again.

  2. dbo October 9, 2012 at 2:46 pm #

    10 hours! Yikes! Good to hear Vikram, glad it worked.

  3. Raj October 11, 2012 at 5:36 pm #

    Thanks a lot. It helped me recover the file I was looking for.

  4. dbo October 11, 2012 at 8:36 pm #

    Sweet! Cheers!

  5. caribbean days google fan page April 15, 2014 at 8:06 pm #

    Imagine resting under the magnificent Mediterranean sea sun overlooking breathtaking provides hiding for and private bays along with
    lush green backdrops of the nature and timeless background
    around you. If your machine doesn't have a 12V DC input
    jack, then you can still use a battery, but you'll have to
    use an inverter. Last but not least, relax with your family for Sunday
    family.

  6. Jeb May 19, 2014 at 12:00 pm #

    Nothing to see here. Help! All I see is the files that I actually saved. The problem is that my work PC restarts on its own schedule without warning, so if I forget to save a file, I'm dead in the water...

Leave a Reply