Recovery Method

Sign in to answer this question.

• 

  Sam Hobbs14y agoPosted Jan 27, 2012, 2:16 AM

  Note that the ability to recreate a database from log data when there is catastrophic failure of a system is not new to SQL Server. IBM computers did it back in the 1970's. Transactions were logged to magnetic tapes and if the database crashed, the database could be recreated from logs.
• 

  Vulpes14y agoPosted Jan 25, 2012, 6:38 PM

  The transaction log is used for recovery purposes.

  
  

  The log contains sufficient information to enable you to undo or redo the changes to the database if something goes wrong.

  
  

  Check this MSDN link for more details:

  
  http://msdn.microsoft.com/en-us/library/aa224747(SQL.80).aspx