Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Saturday, July 26, 2014 6:57 AM
Points: 1,502, Visits: 2,670
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: Monday, June 2, 2014 11:18 AM
Points: 6, Visits: 79
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: Thursday, June 12, 2014 8:13 AM
Points: 8, Visits: 105
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: Friday, July 11, 2014 1:49 AM
Points: 968, Visits: 349
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: Wednesday, May 7, 2014 12:50 AM
Points: 3, Visits: 7
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: Saturday, July 26, 2014 8:10 PM
Points: 2,826, Visits: 8,463
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: Wednesday, August 28, 2013 2:29 PM
Points: 4, Visits: 66
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: Monday, March 31, 2014 9:19 AM
Points: 314, Visits: 677
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 @ 8:24 AM
Points: 12,887, Visits: 31,835
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1469002
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse