Tracking Incremental Data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Tracking Incremental Data

Author

Topic

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2003-12-08 : 02:21:24

Hi All,

I want to have incremental data on a secondary server from
a primary server. One option which I have thought of
is "To add a timestamp field to all the table" and use DTS
to get it.

Please can you tell me is this the best way. Please tell
me if you know anything better than this.

Sachin Samuel

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2003-12-08 : 03:16:53

Sachin, what do you mean by incremental data? Did you consider "Replication" or "Log shipping"? More details are available in the Books Online.

Owais

We make a living out of what we get, but we make a life out of what we give.

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2003-12-08 : 05:36:24

Hi Mohdowais,

Thanks for the prompt reply. By Incremental data I mean only those data which are changed or modified. I have even considered log shipping but found some article saying that it doesn't works properly with Servers on cluster.

Please explain and help me.

Thanks a Million

Sachin Samuel

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2003-12-08 : 06:43:01

I think Transactional Replication is what you are looking for:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/repltypes_7syn.asp

Owais

We make a living out of what we get, but we make a life out of what we give.

mannu_leo
Starting Member

4 Posts

Posted - 2003-12-09 : 10:25:11

Hi,
I have the same issue. Well I have a Clustered environment and I tried Log Shipping but that was not giving any error but was not working at all. it just ran once while copying the whole data across to the secondary server and after that It neither turned up with ne error not it copied the data across and after some R&D I found a Microsoft article that on Clustered Environment there is a bug related with Log Shipping.

And the reason I dont want to go for the Transaction Replication is that the Development is yet not closed and there are many frequent changes in the structure itself. Though we have ways to get those changes in action but that would be lil bit difficult to manage as we can't afford the downtime of more than 3 mins.
And this same reason holds for Log Shipping too.

What do you all suggest???...

Regards,
Manoj Verma
DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources