Sign in
Microsoft.com
 
SQL Server TechCenter
 
 
 
SQL Server TechCenter > SQL Server Forums > SQL Server Disaster Recovery and Availability > What does 'Saving Auto Recovery Information' actually do - definition (SQL Server 2005)
Ask a questionAsk a question
Search Forums:
 

AnswerWhat does 'Saving Auto Recovery Information' actually do - definition (SQL Server 2005)

  • Wednesday, October 28, 2009 7:12 PMCaptSky Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I trying to find an answer to what does 'Saving Auto Recovery Information' actually do.  I know how to turn it of but how does it work?
     

Answers

  • Wednesday, October 28, 2009 7:57 PMTiborKMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote
    Where do you see this? In Manegemtns Studio? If so, SSMS saves information so that if the computer craches, it can suggest that you open the files at least auto-recovery point in time.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    • Marked As Answer byCaptSky Thursday, October 29, 2009 1:24 PM
    •  
     

All Replies

  • Wednesday, October 28, 2009 7:57 PMTiborKMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote
    Where do you see this? In Manegemtns Studio? If so, SSMS saves information so that if the computer craches, it can suggest that you open the files at least auto-recovery point in time.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    • Marked As Answer byCaptSky Thursday, October 29, 2009 1:24 PM
    •