Database backup required?

Undo for SQL Server.

Moderator: eddie davis

Database backup required?

Postby mohaaron » Tue Jan 16, 2007 12:54 am

Why is a database backup required for log rescue to work? I need to be able to read the log file and make a fix without having a backup file. Is this possible?
mohaaron
 
Posts: 29
Joined: Wed Jun 28, 2006 9:04 pm

Postby Brian Donahue » Wed Jan 17, 2007 1:57 pm

Hello,

If you want the maximum amount of accuracy, you will need the log file. Log Rescue is designed to get back whatever it can, but without the schema information it gets from the full backup, the undo and redo scripts could possibly retrieve the information incorrectly.
Brian Donahue
 
Posts: 6668
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