Live Log Retrieval in v1.2

Undo for SQL Server.

Moderator: eddie davis

Live Log Retrieval in v1.2

Postby DECramlet » Fri Nov 16, 2007 4:36 pm

I notice in the Announcement "SQL Log Rescue 1.2 released," Mr. Mellors mentions that, "live log retrieval is now optional."

I am having difficulty finding information about this in the Help File, and was wondering if anyone could tell me:
  • How to skip live log retrieval, and
  • The originally intended use for this feature
Any information would be appreciated.

Thank you.
DECramlet
 
Posts: 1
Joined: Fri Nov 16, 2007 4:22 pm

Postby Brian Donahue » Wed Jan 30, 2008 6:49 pm

Hi,

Yes, I think it's time for us to document this hidden feature. It's enabled by a registry key:
To disable live log retrieval, create a registry entry named "Retrieve live log" and set its DWORD value to zero. Note that clicking the refresh button on the SLR GUI will still retrieve the live log even if the registry value is set to zero - it just won't retrieve the live log by default when you finish the project wizard.
Disabling live log retrieval is useful when the server is in a state that is causing SQL Log Rescue to hang or timeout because either the log file is damaged or transactions are hung. When live log retrieval is disabled, Log Rescue gets the transactions from any supplied transaction log backups instead.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests