sql log rescue and SQL server cluster

[ppang]

Does anyone know if SQL log rescue work with SQL 2k cluster?

Thanks a lot

Peter

[Brian Donahue]

Hi Peter,

Absolutely yes! I'd just given it a quick run on my SQL 2000 cluster server from my local workstation. If it gives you any trouble please let me know!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[defense]

Hi Brian!

How can I install Log Rescue on sql 2k cluster?

[Brian Donahue]

Hi Defence,

That's a good question. There in only one server component, and that is the extended stored procedure, which is a dll and an entry in the master database. Log Rescue, when run from the client workstation, will automatically install and configure this. Now what I don't know is what happens when the server fails over. I think in that case, the configuration would fail over, but I can't see the .dll file getting copied automatically. I think that if this happens, you can manually uninstall and reinstall the extended stored procedure from the Tools menu of Log Rescue. I'd imagine that would straighten it out again.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521