• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4587
  • Last Modified:

Redo Logs for SQL Server

Oracle has Redo Logs for 'Undeleting' records.

What is equivalent in SQL Server?

I need to find any reference to records that were deleted.


  • 2
3 Solutions
There really isn't  a "direct" counterpart.  SQL Server has the transaction log that (if the recovery mode is setup right) will allow you to do point in time restores to the database.  However, you can't browse the transaction log without a third party tool (logexplorer from lumigent is nice http://www.logexplorer.com)
Eugene ZCommented:
Answer: transaction log  
[from http://www.akadia.com/services/sqlsrv2ora.html]

Each SQL Server transaction log has the combined functionality of an Oracle rollback segment and an Oracle online redo log. Each database has its own transaction log that records all changes to the database and is shared by all users of that database. When a transaction begins and a data modification occurs, a BEGIN TRANSACTION event (as well as the modification event) is recorded in the log. This event is used during automatic recovery to determine the starting point of a transaction. As each data modification statement is received, the changes are written to the transaction log prior to being written to the database itself. For more information, see "Transactions, Locking, and Concurrency" later in this paper.

SQL Server has an automatic checkpoint mechanism that ensures completed transactions are regularly written from the SQL Server disk cache to the transaction log file. A checkpoint writes any cached page that has been modified since the last checkpoint to the database. Checkpointing these cached pages, known as dirty pages, onto the database, ensures that all completed transactions are written out to disk. This process shortens the time that it takes to recover from a system failure, such as a power outage. This setting can be changed by modifying the recovery interval setting by using SQL Server Enterprise Manager or with Transact‑SQL (sp_configure system stored procedure).
transaction log is not the same thing as a redo log....but it's as close as you get...if the recovery model is set to simple, you won't be able to obtain the same information you would from a redo log....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now