Cannot Access Beyond Live Log

Undo for SQL Server.

Moderator: eddie davis

Cannot Access Beyond Live Log

Postby tmctear@eyeonwave.com » Thu Jul 05, 2007 3:39 pm

I am not able to access anything further back in history other than what is being pulled from the live logs. I have daily .bak and .trn files that I am generating which should contain this data. My recovery model is also set to Full.
tmctear@eyeonwave.com
 
Posts: 2
Joined: Thu Jul 05, 2007 3:37 pm
Location: Columbus, OH

Postby Robert » Thu Jul 05, 2007 5:47 pm

Hi there,

When you selected the backups to use, did SQL Log Rescue produce any warnings? Specifically, ones regarding gaps in the log chain or similar?

Thanks,
Robert
Robert Chipperfield
Red Gate
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK

No Messages

Postby tmctear@eyeonwave.com » Thu Jul 05, 2007 9:02 pm

There were no messages or errors given after importing the logs.
tmctear@eyeonwave.com
 
Posts: 2
Joined: Thu Jul 05, 2007 3:37 pm
Location: Columbus, OH

Postby Robert » Thu Jul 05, 2007 11:43 pm

In that case, would you mind creating a directory named "logs" in your SQL Log Rescue installation folder?

Make sure the user you're running SLR as has the appropriate permissions to write to this folder, then close and open SLR if it was previously running. Then, go through the wizard, selecting your backups and so on, allowing it to process the logs and show you the list of log entries.

If you then look in the logs directory, you should (with a bit of luck) have a text file with a load of debugging information in it.

If you could email this to me at robert [dot] chipperfield [at] red-gate [dotcom], I'll take a look and see if I can see where things might be going wrong.

Thanks,
Robert
Robert Chipperfield
Red Gate
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests