Unavailable values

Undo for SQL Server.

Moderator: eddie davis

Unavailable values

Postby harryb » Fri Nov 10, 2006 9:38 am

You say "The data from the log could be unavailable because the data has been overwritten in the log. This could happen on databases that use the Full recovery model when a full backup is done. It could also be that the database is using the simple recovery model. In the latter case, there is no guarantee that the data will be available."

Surely, having Full Recovery is a normal case and taking Full backups is a normal case.

We take backups once a day and backup the logs every two hours, why would data be unavailable for many logs in the day?
harryb
 
Posts: 4
Joined: Fri Nov 10, 2006 9:19 am

Postby Brian Donahue » Sat Nov 11, 2006 4:41 pm

Hi Harry,

I think the idea of the original information is about the whole transaction not appearing in the Log Rescue screen rather than a transaction that has been identified, but the data is unavailable.

I'm not totally sure about all of the reasons why the data would be unavailable. I'd have to get back to you about that.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby harryb » Mon Nov 13, 2006 2:11 am

If you need any examples / screen shots / logs, let me know.

Cheers

Harry



Brian Donahue wrote:Hi Harry,

I think the idea of the original information is about the whole transaction not appearing in the Log Rescue screen rather than a transaction that has been identified, but the data is unavailable.

I'm not totally sure about all of the reasons why the data would be unavailable. I'd have to get back to you about that.
harryb
 
Posts: 4
Joined: Fri Nov 10, 2006 9:19 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 1 guest