Red Gate forums :: View topic - No full database backup specified (?!)
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

No full database backup specified (?!)

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
rdalton



Joined: 26 Oct 2005
Posts: 25

PostPosted: Thu Mar 09, 2006 4:44 pm    Post subject: No full database backup specified (?!) Reply with quote

I've copied a backup of the database and log files to another server and installed the database. (because of the locking problems, i'm not comfortable running this on a production server)

When i try to look at the log files, I get a High Severity error 'No full database backukp specified. Sql Log Rescue may not be able to fully recover all data'.

I've tried including the full backup file in the file list and not including it in the file list. It gives me the same error either way.

How can I read the log file?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Thu Mar 09, 2006 7:07 pm    Post subject: Reply with quote

Hello,

If you do not want to analyze a live log file on a production server, there is a bit of a procedure that you need to follow. First of all, you need a collection of backup files: The last full backup and all of the log backups up to the current time.

First, restore only the full backup to the offline server so that the database is operational. Next, start Log Rescue and point it at the database. Next, add all of the backup files (starting at the latest FULL that you had just restored and then all of the log files afterwards).

Start the analysis. Log Rescue will now show you all of the transactions contained inside the transaction log backups (rather than the live log).
Back to top
View user's profile Send private message
rdalton



Joined: 26 Oct 2005
Posts: 25

PostPosted: Thu Mar 09, 2006 7:25 pm    Post subject: no luck Reply with quote

Same error. I'm using 1.0 rather than 1.1 of log explorer because 1.1 gives me a program error.

Can I restore differential backups or just the full?
Would changing the database .mdf and .ldf files cause a problem?
do i need a specific version of sqlbackup?
Would it work better if i ran it on the live database?
Back to top
View user's profile Send private message
rdalton



Joined: 26 Oct 2005
Posts: 25

PostPosted: Thu Mar 09, 2006 7:43 pm    Post subject: more fun Reply with quote

i uncompressed all the backup files to see if that was the problem and it let me continue and recognized everything but while it's processing the logs it blows up with

redgate.logrescue.ui.exe = common language runtime debuging services
application has generated an exception that could not be handled

process id = 0xd58(3416) thread id = 0xx74c(11868)

I can't debug because i don't have anything installed.

am i looking at too many log files?
will the 1.1 version fix this? (i don't think so because i was getting this in the 1.1 but that was before i uncompressed everything)
Back to top
View user's profile Send private message
rdalton



Joined: 26 Oct 2005
Posts: 25

PostPosted: Thu Mar 09, 2006 7:59 pm    Post subject: more info Reply with quote

I was loading the files one at a time and got a

Index was outside the bounds of the array
Back to top
View user's profile Send private message
rdalton



Joined: 26 Oct 2005
Posts: 25

PostPosted: Thu Mar 09, 2006 8:29 pm    Post subject: Reply with quote

it took about 5 files before i got that error and it give me that error on all subsequent files.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Fri Mar 10, 2006 11:11 am    Post subject: Reply with quote

Are these SQL Backup log backup files or native (MTF) files, or perhaps a combination of both? There could be some corrupt backup headers.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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