Recovery Method

Question

Hi what is the Transaction Recovery Method in sql server? Thanks

Sam Hobbs · Answer

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.

Vulpes · Answer

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