Recovery on a new server.

Undo for SQL Server.

Moderator: eddie davis

Recovery on a new server.

Postby johnnylundgren » Tue Nov 15, 2005 4:51 pm

Hello,

Can I use this tool to recover from logs to a completely different server ?

My environment:

A two-node SQL2000 cluster with data and logs on different disks and an additional (non-cluster) server on which to make regular SQL disaster recoverys.

Is this the optimal tool to do what I need to do ?

Regards

Johnny Lundgren
johnnylundgren
 
Posts: 1
Joined: Tue Nov 15, 2005 4:45 pm

Postby Brian Donahue » Tue Nov 15, 2005 10:31 pm

Hello Johnny,

I believe so. SQL Log Rescue analyzes the actual log (LDF file) by querying the server for its' location, then copying the LDF to the computer running log rescue so it can be analyzed off-line. If you want to undo or redo all or part of a transaction, you can tell Log Rescue to produce a SQL script that you can run in Query Analyzer.

Provided your target has matching schema and data close enough so the query will not fail, you can run the SQL Script on any database you'd like.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests