October 27, 2008 at 9:37 pm
Can we do the replications by reading transactions logs ?
October 28, 2008 at 1:05 am
Do you mean "Log Shipping"?
October 28, 2008 at 1:53 am
No,I have to write windows service to do the replication instead of using the sql server management studio.
I thought i have to read the log file of the database to get the new changes of the database.But i couldn't find a way to understand the log file.
October 28, 2008 at 2:06 am
Why can't you use the standard transactional replication? This type of replication reads from the transaction log, so it should provide everything you need.
[font="Verdana"]Markus Bohse[/font]
October 28, 2008 at 2:14 am
I have done it using standard transactional replication, its working properly.But I have to do it using another way.
Can I read the transactional log of a database to do this or can I read the cache of the server to get sql commands which were exacted recently ?
October 28, 2008 at 10:08 am
What you can do is set up a job to back the t-log up frequently and then have a job on the other server to restore the log to a database in restore mode. This wont be triggered on each new batch of transactiosn though, only new trans since the last backup.
Of cource you could have some sort of sql command line tool which can periodically do the same by processing a batch file of sql code (ie connect to server a, run log backup to ntfs. connect to server b, restore log from ntfs allowing restore etc).
This could then be scheduled to run through windows. Any good? :ermm:
Adam Zacks-------------------------------------------Be Nice, Or Leave
October 31, 2008 at 2:15 am
Thanks Schadenfreude-Mei,
I have done it by creating "Traceserver" object and keeping all transactions in a table.Then I update second database using those transactions ,for a schedule.
I will test it on ur way also.
Thanks
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply