Red Gate forums :: View topic - "Fake" SQL Replication
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

"Fake" SQL Replication

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



Joined: 19 Jul 2007
Posts: 17

PostPosted: Sun Feb 10, 2008 1:24 pm    Post subject: "Fake" SQL Replication Reply with quote

A little history before my question...

I have a database that is about 90-100GB of data that I'm trying to replicate between servers. The catch is that I want both Databases live. The primary OLTP database will handle transactions, and the second database needs to be live (within the replication latency) for reporting to take a load off the primary server.

This database is from a 3rd party vendor, so I have limited control over when updates are made. Additionally, since the users are on 24x7 they don't want to give the repeated time necessary to take a snapshot for replication if the vendor makes a schema change. We could do a backup, and create the replication objects manually, but that would get tideous to repeat for any changes, since we would have to disable triggers and things like that on the "report" database each time as well.

I thought about using Log Shipping, but that would kick out any connections that were active when the system restores the individual files. For 6 or 12 hour latency that would be a problem, but every 30 minutes or so would get annoying.

Here's where Log Rescue hopefully comes in... If it can create a "Redo" script that will run all of the transactions in the database, I can keep the "reports" database fully live, and just apply the Redo script to the second server. Can Log Rescue be scripted for a purpose like this. Reading the Transaction Log backups would allow me to apply updates to the reports database with zero impact on the live production server.

Thanks for any assistance you can provide.
_________________
--wayne
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Tue Feb 12, 2008 4:37 pm    Post subject: Reply with quote

Thank you for your post into the forum.

Unfortunately SQL Log Rescue is NOT the tool for replicating data between two databases.

SQL Log Rescue is a disaster recovery tool to repair the damage from deletion of data or of database objects.

SQL Log Rescue only supports Microsoft SQL Server 2000.

If you wish to replicate data between two live databases, I strongly recommend that you evaluate our SQL Data Compare tool.

SQL Data Compare enables you to compare and synchronize the data in two Microsoft SQL Server databases. You can also compare a backup with a database, or with another backup. SQL Data Compare enables you to synchronize multiple tables whilst maintaining referential integrity.

Further advice regarding SQL Data Compare can be found on these pages on our web site:

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

http://www.red-gate.com/support/SQL_Data_Compare/index.htm

Many Thanks
Eddie

Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-Mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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