Auto Save / Auto recover in Management Studio?

Question

Auto Save / Auto recover in Management Studio?

Viewing 15 posts - 16 through 30 (of 32 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Armstrong SSC Enthusiast Points: 155 More actions · Answer 1

Thank you so much, your post completely saved my bacon!!!! :-D:-D:-D:-D:-D:-D

Aalam Rangi SSC Veteran Points: 278 More actions · Answer 2

Windows XP and Windows 7 have different locations for the recovered files.You can the OS specific locations at this blog post -
http://www.sqlerudition.com/recover-unsaved-queries-after-ssms-crash/

Aalam Rangi SSC Veteran Points: 278 More actions · Answer 3

Windows XP and Windows 7 have different locations for the recovered files.

You can the OS specific locations at this blog post[/url].

jyz SSChasing Mays Points: 613 More actions · Answer 4

jyz

SSChasing Mays

Points: 613

May 2, 2012 at 9:01 am

#1482457

Thanks a lot.. 🙂

Jatin Soni SSC Eights! Points: 933 More actions · Answer 5

Big thank you. your post saved me from lot of trouble this morning.

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 6

In my case the blog post for Windows 7 was not correct. I found the auto-recover files at

C:\Users\<user_name>\Documents\SQL Server Management Studio\Backup Files\Solution1

Aalam Rangi SSC Veteran Points: 278 More actions · Answer 7

Aalam Rangi

SSC Veteran

Points: 278

August 10, 2012 at 10:20 pm

#1524736

Thank you! Updated the post now.

arbcoll Old Hand Points: 317 More actions · Answer 8

Back to the issue SSC Veteran reported on the second post of this topic, I had the same experience - lost my 2 day work after an autorestart during weekend, caused by Windows Updates ( :angry: ). The autosaved files are missing - couldn't find them nowhere in the disk...

Million dollar question is why in a hell autosave doesn't work on Windows Updates restart sometimes?

anders-731262 Ten Centuries Points: 1256 More actions · Answer 9

Thanks,

This thread just saved me a couple of hours work. From now on I will CTRL+S more often 🙂

/ah

nikimpatel Valued Member Points: 64 More actions · Answer 10

Thanks for sharing solution. It's save my work and time.

🙂

ryanm-829779 Valued Member Points: 67 More actions · Answer 11

ryanm-829779

Valued Member

Points: 67

January 24, 2013 at 12:54 pm

#1580687

You rock! Thank you for sharing 🙂

homebrew01 SSC Guru Points: 55548 More actions · Answer 12

anders-731262 (11/9/2012)
Thanks,
This thread just saved me a couple of hours work. From now on I will CTRL+S more often 🙂
/ah

I click "save" all the time. Cheap insurance.

SSC_newbie SSC Rookie Points: 44 More actions · Answer 13

this tread saved me a whole lot of writing. Thanks

Rob-350472 SSCertifiable Points: 7197 More actions · Answer 14

Glad it's still helping people, on a slight side note, I can't recommend SSMS Tool Pack enough for this kind of thing, a colleague fell foul of a rogue restart over the weekend and the auto recover files didn't go back far enough for some reason.

SSMS tools keeps the full log of what's been going on in SSMS, http://www.ssmstoolspack.com/

Well worth taking the 5-10 mins to install and have a play that's for sure 😀

Lowell SSC Guru Points: 323518 More actions · Answer 15

arbcoll (10/10/2012)
Back to the issue SSC Veteran reported on the second post of this topic, I had the same experience - lost my 2 day work after an autorestart during weekend, caused by Windows Updates ( :angry: ). The autosaved files are missing - couldn't find them nowhere in the disk...
Million dollar question is why in a hell autosave doesn't work on Windows Updates restart sometimes?

Get a copy of the SSMS Tools Pack: http://www.ssmstoolspack.com/

One of it's features is that it saves your SQl history...if you executed a SQL, it keeps a backup copy of it.

This saved my tail several times, where i was overzealous with "X"-ing out windows, and close one i really intended to save.

imagine you did an investigative query weeks ago, and the problem resurfaces again? but you didn't save that preliminary scripts?no problem, instead of starting from scratch, you can go to the history, and find all queries, in a certain date range, that has a string or tablename or object name in it.

I highly recommend it just for that feature alone, let alon it's many other features.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!