Red Gate forums :: View topic - Newbie Question
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

Newbie Question

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
Hammermaninmd



Joined: 10 Oct 2006
Posts: 1

PostPosted: Tue Oct 10, 2006 4:05 pm    Post subject: Newbie Question Reply with quote

Hello all.. I am thinking of buying a copy of LOG Rescue and had a question I didn't see answered in any of the demos or FAQ's. If I have a suspect database or a torn page can I use Log Rescue to find the transaction that caused the issue and roll it back? I ask because looks like you have to physically attach to the db and if the db is suspect you may not be able to attach. I have seen mention of using Log Rescue for disaster recovery - can you point me to some thread or info on how LR can be used for Disaster Recovery?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Tue Oct 10, 2006 6:37 pm    Post subject: Reply with quote

Hi Ken,

Log Rescue would definitely not be the tool to use in this case. It assumes that you have a fully-working, consistent database. The way in which it helps recover data in the case of a disaster is if an unwanted query had been run, for instance:
  • You had been the victim of the fables SQL Server 'injection' attack
  • A rogue (or poorly trained) employee enters a query with no WHERE clause
  • An administrator 'accidentally' drops a table
If the database is unavailable or broken in any way, it would be difficult or impossible to use Log Rescue with it, but if the database is functional and some data had accidentally been updated or deleted, it would be the tool to use to get it back.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group