Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

install Infosphere CDC SQL 2000 Expand / Collapse
Author
Message
Posted Thursday, January 20, 2011 2:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 31, 2011 1:47 AM
Points: 1, Visits: 15
I’m trying to install IBM Infosphere CDC (old DataMirror Transformation Server) and I receive the message:
IBM Infosphere Change Data Capture has detected multiple backups to the same file: C:\backups\mybase.trn.

I deleted the file mybase.trn but still receive the same message.
There is a requirement of Infosphere CDC to have only one backup in each file.

I have SQL server 2000 SP4.
Can anybody help me?
Post #1051198
Posted Friday, February 25, 2011 4:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 25, 2011 7:54 AM
Points: 4, Visits: 39
have you checked the backup settings in infosphere, it may well be the case it is holding the old file path in two places.
Post #1069507
Posted Wednesday, November 23, 2011 5:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 23, 2011 11:00 PM
Points: 1, Visits: 5
Hi santuzzo01,

Hope you have resolved your issue with the backup. Seeing that you've got that kind of a problem tells me that you have made some progress at least with somewhat running the CDC against SQL Server 2000. I am currently trying to set it up for evaluation.
Maybe you can advise me with how to resolve a problem I have. There is a clear need behind having to have CDC metadata tables in a separate schema (database) to the one I want to replicate. Regardless of how I set up the dedicated CDC user and DB I am not able to get the CDC to put those 3 tables whilst creating the very first CDC instance.
I tried getting in touch with IBM but they are not really able to help so far.
What was you experience with this? Were you able to separate the CDC tables?

Thanks,

Dario
Post #1211410
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse