Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

Auto Save / Auto recover in Management Studio? Expand / Collapse
Author
Message
Posted Thursday, August 9, 2012 10:55 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 1,606, Visits: 2,950
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
Post #1342852
Posted Friday, August 10, 2012 10:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 9, 2015 9:41 PM
Points: 7, Visits: 121
Thank you! Updated the post now.
Post #1343742
Posted Wednesday, October 10, 2012 1:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 11, 2015 3:29 AM
Points: 9, Visits: 162
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 ( ). 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?
Post #1370745
Posted Friday, November 9, 2012 1:21 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 4, 2015 2:33 PM
Points: 997, Visits: 355
Thanks,
This thread just saved me a couple of hours work. From now on I will CTRL+S more often :)
/ah
Post #1382874
Posted Monday, December 10, 2012 5:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 3:35 PM
Points: 3, Visits: 9
Thanks for sharing solution. It's save my work and time.

Post #1394829
Posted Thursday, January 24, 2013 12:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 2:55 PM
Points: 5, Visits: 115
You rock! Thank you for sharing :)
Post #1411313
Posted Sunday, January 27, 2013 2:37 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 5, 2016 10:50 AM
Points: 2,922, Visits: 8,967
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.



Post #1412150
Posted Tuesday, June 25, 2013 2:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 3, 2015 2:05 PM
Points: 4, Visits: 69
this tread saved me a whole lot of writing. Thanks
Post #1467380
Posted Monday, July 1, 2013 4:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 6, 2015 4:34 AM
Points: 315, Visits: 678
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 :D
Post #1468995
Posted Monday, July 1, 2013 5:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:48 PM
Points: 14,458, Visits: 37,962
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 ( ). 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!
Post #1469002
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse