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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-09-26 : 04:55:14
|
| Dear All,we have three servers xns016,xns017 and xns200. xns016 is the production server and xns017 is the replication server.some data will be entering from xns200 server to xns016 server. the xns016 server is 6 minutes faster than the xns200. that is getting some internal problem to the applications(exceptions as well SMS's are giving trouble).now i need to directly change the timings of server, but per minute around 450 rows are inserting into the database. so changing the time will affect the previous data(so many datetime columns are there).so please suggest me how can i achieve this without affecting the replication between xns016 and xns017please help me in this regardArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-09-26 : 06:40:42
|
| i've planned to do like this please guide me and correct me.first i'l stop the replication (i dont know how to stop please help me)after that i'l stop the service of sql server for xns16after 6 minutes i'l start the serviceafter that i'l start the replication(i dont know how to start again please help me)i don't want to take a new snapshot again. as that takes much time. please help me in this regard ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-26 : 07:39:50
|
Why not use Time Service (NTP) to synchronize your servers across network?Do that first, and then you may have to manually deal with the missing records later.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
server time adjustments help please