CrazyMan (6/8/2008)

---

HI Pong

I had the same problem with one of my servers, i checked all codes, there was a new SP that...

Its a unidirectional replication with immediate update. We didn't such errors before, so I can tell that it will not replicate until it commits on publisher. My guess is someone...

Any other ideas guys..I want to fix or reason this weird behavior but haven't found any help...Thanks.

Yes, I know my best bet is to find why PK violations happened in the first place. But, these duplicate data was rejected by SQL Server already, then why did...

Thanks for the suggestions Gail...

GilaMonster (3/17/2010)

---

No, you don't want to run a checkDB every time you back the log up. That's just insane. If you're backing up every 15 min, CheckDB can easily take...

GilaMonster (3/17/2010)

---

Put it this way. Would you...

I have couple of questions now..

1. How much overhead would it add if I include a verify backup when finished, is there a way to test it out.

2. With a...

CirquedeSQLeil (3/17/2010)

---

If you're allowed data loss is 30 minutes, then either amount of time would be fine.

With 15 minutes, less data loss = better. The backup time should be...

Even I am tempted...

Jeff Moden (3/8/2010)

---

T-SQL_NewBie (3/8/2010)

---

Jeff Moden (3/7/2010)

---

T-SQL_NewBie (3/4/2010)

---

I have been told by my manager that SSIS 2008 is slower than Hibernate for data migration, apparently because of cache problems..how do I...

Gift Peddie (3/7/2010)

In my experience most applications that uses ORM (object relational mapper) like Hibernate do not use constraints and DRI (declarative referential integrity) things that tools like SSIS maintains...

Jeff Moden (3/7/2010)

---

T-SQL_NewBie (3/4/2010)

---

I have been told by my manager that SSIS 2008 is slower than Hibernate for data migration, apparently because of cache problems..how do I reason that SSIS...

Hibernate was there for the last one year, but the change is that it will be used for the data migration to new system based on SQL Server 2008, apparently...

Thanks for the reply. I used SSIS already and the results were convincing with a million odd records, but the daily job only processes somewhere around 100K records, which is...