Are you backing up the t-log? Are your subscribers all getting data?

Is this the publisher or distributor log?

Check data size

Check indexing in both

check the execution plans

calvo (5/4/2012)

---

Yeah, that's real tough for him. On the verge of retirement but still the best in the game then BAM, done. All in the blink of an eye.

Let's hope...

Mark-101232 (5/4/2012)

---

Now...

You may be right. I haven't done enough formal SCRUM to know. But I have seen things slip down the list. It's not that someone doesn't advocate, but that there...

Change or disable the alert. It makes no sense to have an alert for a condition that is already exceeded.

Bhuvnesh (5/4/2012)

---

It means that there should not be any connection (some process is using) with those files but why this case doesnt get applied on...

Great advice from Gus, but one thing I'd also add to my list to circle back on is to make sure that you round robin to all groups before too...

There are scripts here on this site to help you automate this. Ideally you restore all backups every day. If not, pick a few test workstations, set up restores on...

Are you using roles here for security to be sure the two users have the same access?

Is there perhaps some other trigger on the table that is causing issues?

Can you...

I think you're both off track slightly here. Apple doesn't do well because of sales. They do well because they've made very intuitive products that work great in some ways,...

How does it display in SSMS? If you look at the raw data, is it correct?

I'm guessing that you have some word wrap issue in SSRS. Does the text box...

Probably, and glad it's moving faster.

Large deletions across a table should be done in batches of 10,000 or 100,1000 or some reasonable level that allows you to stop it if...

The distributor cannot be a lower version than the publisher, that's the issue.

If you log ship to ServerB, it will work, but if you failover, you are stuck on 2008...

Are they all located in the same network area? Same subnet, physical location?