Database backup required?

Undo for SQL Server.

Database backup required?

Postby mohaaron » Mon Jan 15, 2007 11:54 pm

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?
Posts: 29
Joined: Wed Jun 28, 2006 8:04 pm

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


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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests