SQL Scrapbook

Short and simple SQL Server posts

Archive for the ‘General’ Category

Recover Management Studio from crash

leave a comment »

Many a times my Management Studio hang up on me. Sometimes the files were automatically recovered but many times i had to loose the sql files i have been working on.
I always thought that there is no way for me to recover the files manually, but actually there is (atleast sometimes) a way for you to restore the files in case of a crash.
Browse to C:/Users/<YourUserName>/Documents/SQL Server Management Studio\Backup Files\Solution1.
If you are lucky enough you will find the sql files that you were working on at the time of crash
Note that you can’t recover files if you close them without saving, obviously.

Written by sqlscrapbook

July 28, 2010 at 7:22 pm

Posted in General

First Post

leave a comment »

Bienvenida… so here it is, my first post on my first blog…Well, my area of interest is SQL Server and that’s what i will be sharing through this blog. I will post my experiences, new things i learned and lot of cool stuff. Never the less the best way to learn is to teach and this is my objective. I am here to learn… Thanks and take care.

Written by sqlscrapbook

July 9, 2010 at 2:17 am

Posted in General