Post reply

SSMS question - Saving Auto Recovery Information...

  • May 9, 2013 at 10:44 am

    #293187

    I know this might be a simple question but I have not been able to find my answer as of yet and thought I would throw it out there in hopes somebody knows the answer. In my SSMS (management studio) I get the 'Saving Auto Recovery Information' message when it is saving off the Auto Recovery Information which I do not have an issue with my issue is the frequency of this seems to set to every couple minutes and I want to set that to every 30min if possible.

    Any help appreciated.

    Microsoft SQL Server Management Studio 10.0.5500.0

    Microsoft Analysis Services Client Tools 10.0.5500.0

    Microsoft Data Access Components (MDAC) 6.1.7601.17514

    Microsoft MSXML 3.04.05.06.0

    Microsoft Internet Explorer 8.0.7601.17514

    Microsoft.NET Framework 2.0.50727.5448

    Operating System 6.1.7601

  • May 9, 2013 at 12:15 pm

    #1613947

    for SQL 2008, I know there's nothing in the GUI to help.

    there's registry keys here which seem to allow you to enable it or disable it, but i don't remember seeing anything about adding a missing key to change the interval:

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover

    AutoRecover Always Enabled

    AutoRecover Enabled

    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!

  • May 9, 2013 at 12:20 pm

    #1613948

    Thanks appreciate the info it is getting very annoying and if I can't set the interval this way I can turn it off.

Viewing 3 posts - 1 through 2 (of 2 total)

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