problem running SQL Log Rescue

[tony_h]

First time user and first install.

Installed SQL Log Rescue 1.2 today and when I run it and go through the create new recovery project, I get stuck.

After LR reads the backups and analyzes them, I click Next. I get the following database error message:

Cannot load the DLL xp_LogRecue.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

Anyone see this before and can tell me what I am doing wrong?

Thanks

[eddie davis]

Hi Tony

Sorry that you are getting this error.

I suspect that the Log Rescue Extended Stored Procedure has not installed correctly or not installed at all on the SQL Server you are trying to analyse.

From the Tools Menu -> Select Install Extended Stored Procedure and follow the instructions that appear on screen.

The xp_LogRescue.dll file should get installed into your SQL Server's BINN folder:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

or

C:\Program Files\Microsoft SQL Server\MSSQL$<instance_name>\Binn
where <instance_name> is the name of your SQL Server Instance.

Eddie Davis
Red Gate Software Ltd
Technical Support

[tony_h]

The file is there and looks as though it has been there since the initial install.

xp_LogRescue.dll exists at C:\Program Files\Microsoft SQL Server\MSSQL\Binn.

The server has been restarted and I am still getting this same error. Any other ideas.

[Brian Donahue]

Hi Tony,

Can you please try performing a manual installation of xp_logrescue on the server?

The instructions are here:

http://www.red-gate.com/help/sqllogrescue/Topics/AccessingOtherServers.html

Scroll to the bottom and you will see the manual installation procedure.

Thanks!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[tony_h]

Maybe I am supposed to know this already, but when I log in to the database server using Remote Desktop (the server is behind a locked door, to which, I don't have the key), launch query analyzer and write the line below:

exec sp_addextendproc 'xp_LogRescue', 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_LogRescue.dll'

I get the following message:

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_addextendproc'.

I didn't perform the install of SQL Server. Was there something not installed or am I missing something?

[Brian Donahue]

Thanks for pointing this out and I'm sorry that the help file has a typo. It should read sp_addextendedproc.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[tony_h]

Sorry I didn't notice that.

When I run the corrected name I get the following error:

Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26
There is already an object named 'xp_LogRescue' in the database.

Looks like it is already installed. Anything else to try?

[Brian Donahue]

Hi Tony,

Can you try this query and see if xp_logrescue works from Query Analyzer?

[tony_h]

When I put this in Query Analyzer:

DECLARE @logfilename nchar(261)
DECLARE @challange int
set @challange = 12345
DECLARE @minFileID int
set @minFileID = 0
SET @logfilename = (select top 1 filename from
CR_PPM..sysfiles1 where (status & 0x40) !=0)
SET @logfilename = RTRIM(@logfilename) + '*'
exec master..xp_LogRescue @challange, @logfilename , @minFileID

I get this result:
ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xp_LogRescue.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

I double-checked the file location and found the dll (xp_LogRescue.dll) here:
C:\Program Files\Microsoft SQL Server\MSSQL\Binn

I really appreciate all of your help.

[tony_h]

I don't know if this makes a difference or not, but I thought I should mention it. I installed the software remotely using Remote Desktop Connection. I was not logged in using the \console switch.

Would this affect anything?

[Brian Donahue]

It shouldn't make any difference; installing the extended stored procedure is a thing that is specific to the SQL Server, you wouldn't need to worry that the application is available to all terminal services users.

What happens when you

exec sp_helpextendedproc 'xp_logrescue'
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[tony_h]

Switching to text output so I can paste here...

name dll
--------------------- ------------------------------
xp_LogRescue xp_LogRescue.dll

[Brian Donahue]

You're not using a 64-bit version of SQL Server, are you? xp_logrescue.dll is 32-bit code and isn't going to work on a 64-bit edition of SQL Server.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[tony_h]

I don't think so. I think the 64-bit version of 2000 requires specific hardware (Intel Itanium - maybe, don't remember exactly).

I don't know if this clarifies but when I run the following statement in QA:

[Brian Donahue]

How about this:

exec sp_dropextendedproc 'xp_LogRescue'
DBCC xp_LogRescue (FREE)
*copy your xp_LogRescue.dll to the SQL Server's BINN directory (C:\program files\microsoft sql server\mssql\Binn)
exec sp_addextendedproc 'xp_LogRescue', 'xp_LogRescue.dll'
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521