SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Auto Save / Auto recover in Management Studio?


Auto Save / Auto recover in Management Studio?

Author
Message
WILLIAM MITCHELL
WILLIAM MITCHELL
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3836 Visits: 3083
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
Aalam Rangi
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 121
Thank you! Updated the post now.
arbcoll
arbcoll
SSC-Enthusiastic
SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)

Group: General Forum Members
Points: 131 Visits: 165
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
anders-731262
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1067 Visits: 362
Thanks,
This thread just saved me a couple of hours work. From now on I will CTRL+S more often Smile
/ah
nikimpatel
nikimpatel
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 9
Thanks for sharing solution. It's save my work and time.

:-)
ryanm-829779
ryanm-829779
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 115
You rock! Thank you for sharing Smile
homebrew01
homebrew01
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12058 Visits: 9222
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 Smile
/ah


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



SSC_newbie
SSC_newbie
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 69
this tread saved me a whole lot of writing. Thanks
Rob-350472
Rob-350472
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1495 Visits: 684
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 BigGrin
Lowell
Lowell
SSC Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70068 Visits: 40923
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search