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.
| Author |
Topic |
|
ay2k_99
Starting Member
22 Posts |
 Posted - 2009-05-11 : 03:00:25
|
| Dear All,We had setup with the Transactional replication for our organization and we have some problem during the setup... like1.) We have one database server which access from 2 application server.2.) One application running the ETL job which copy data from other server and dump in to the publisher database. this will take around 3 hr to transfer the data. During the tran. replication around 25-30 million records are access read in the log file.3.) from the other application server one table is modifying the table during that time ETL is running so, i found the deadlock on table.4.) our main scenario to when ETL job is running that time we need to pause or stop the replication.i had done using sysjobs to deactivate the running replication job. but no used...Thanks,Amey |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-11 : 22:52:47
|
| Can't you run that ETL jobs in off hours when other apps are not modifying data? so this is not a problem with replication. This is problem with how the ETL process you have set up. |
 |
|
|
ay2k_99
Starting Member
22 Posts |
Posted - 2009-05-12 : 00:37:47
|
| Hi,Thanks, this application is specific and run in BFSI domain, so there is no fixed time to run that perticular time.. like this is user generated reports. so, any user can run that report from any where...! |
|
|
|
|
|
|
Replication (STOP + START) issue...