DNS alias?

You have a total of 702GB on source, 764GB on destination (unless I've missed one somewhere).

The only way to get this restored on the destination is to prepare and plan...

I was wondering if you'd updated all the stats on the 2008 subscriber since upgrading the server?

I would consider running...

I'm assuming network speed/bandwidth has been eliminated since it was a SQL upgrade.

So this may be down to differences in functionality between the 2000 distribution agent and 2008. Maybe...

Restarting the passive node would do it, but that's overkill.

I use powershell when moving the cluster groups around.

Get-ClusterGroup

Get-ClusterGroup | Move-ClusterGroup

None of those would make...

It looks like the delivery of commands is whats taking the time. Have you compared the distribution agent profile settings between the servers?

chris.roddis-ferrari (11/14/2013)

---

Some are worse than others, but there is latency across all the new servers. There was a correlation to the number of records in msrepl_commans and performance. But even...

Also, is the latency across all subscribers?

The clustergroup doesn't failover automatically along with the application groups.

You can safely move this group on to the active cluster. Im not aware of any impact if you don't....

Have you established where the latency is?

Log reader to distribution server?

Distribution agent to subscriber?

Powershell is an option.

or

exec sp_msforeachdb 'USE ?; SELECT ?;'

Personally, I'd consider writing a generic powershell script which took a .sql file as parameter.

Koen Verbeeck (11/13/2013)

---

Beatrix Kiddo (11/13/2013)

---

Can this be used as a way to get access if you don't know any of the passwords? I definitely didn't give this guy access- he...

Is there a BUILTIN\Administrators group in your login list?

I would guess that Oracle is performing an implicit conversion or the date is being interpreted incorrectly somewhere.

Have you checked the dates on the source system directly and...