Red Gate forums :: View topic - Recovery on a new server.
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

Recovery on a new server.

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
johnnylundgren



Joined: 15 Nov 2005
Posts: 1

PostPosted: Tue Nov 15, 2005 4:51 pm    Post subject: Recovery on a new server. Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Tue Nov 15, 2005 10:31 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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