Viewing 13 posts - 16 through 28 (of 28 total)
As i am using SQL Server 2005, i think the update statement is delivered as update only, but not pair of delete/insert.
February 24, 2011 at 3:23 pm
I am actually using pull subscription
January 27, 2011 at 3:43 pm
Satnam Singh (1/24/2011)
By replication scripts, it means that it is the backup of your replication.
Could you provide me with the steps i need to follow for initializing replication from backup
January 24, 2011 at 10:33 pm
Satnam Singh (1/24/2011)
Ideally the replication information is stored in the distribution database ie information regarding publishers, subscribers and so on. Therefore restoring the publisher database again will not...
January 24, 2011 at 10:22 pm
Satnam Singh (1/24/2011)
Has the database backup which u r talking to restore been taken after the replication is set?Satnam
The backup is of the publication database, which is being replicated previously.
January 24, 2011 at 10:03 pm
Thank you jeff,
After using the square brackets it worked well.
January 17, 2011 at 8:25 pm
could you please provide me with some of examples
January 14, 2011 at 8:00 pm
GilaMonster (1/13/2011)
What do you need to see?The resultant data change for each transaction?
The exact insert/update/delete that was run?
Selects as well?
I need to capture insert/update/delete that happened to that database
January 13, 2011 at 6:12 pm
homebrew01 (1/12/2011)
OP, perhaps you can more fully explain your goal and environment. Then you will most likely get some good suggestions.
We are replicating(transactional replication) a database from a client, now...
January 12, 2011 at 7:33 pm
sachnam (1/11/2011)
Dj463 (1/11/2011)
.I would suggest to go with import\Export of for all the tables which you want to archive with date limits.
I tried import/export tables but i was not able...
January 12, 2011 at 7:26 pm
OK, is there any way i could capture all the transactions occurring in that database other than C2 audit?
January 11, 2011 at 10:55 pm
Thanks for the reply sachnam,
As that database is already being replicated(Transactional replication). If we keep the subscriber database on separate server and modify replication in order to not propagate deletes...
January 11, 2011 at 10:48 pm
Thanks for reply Sachnam,
Well as i said full backup of the database is taken daily, my concern is if i take transactional log backup monthly will it contain all the...
January 11, 2011 at 10:16 pm
Viewing 13 posts - 16 through 28 (of 28 total)