Home Forums SQL Server 2005 SQL Server 2005 General Discussion Auto Save / Auto recover in Management Studio? RE: Auto Save / Auto recover in Management Studio?

  • July 1, 2013 at 5:29 am

    #1628662

    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!