I posted this to the wrong group rather than deliberatly cross-posting.

Clutching a straws really. Ww couldnt work out why these subscriptions got marked as inactive so we

attempted to each day make sure they are active.

Dave

Hi,

Snapshot replication takes place evey 24hrs.

I've not tried setting the option 'next expire' to be every '336 hours' as you suggest. Is this

likely to make any...

MG (12/20/2007)

---

MS will not produce a 64 bit...

Mike Seddon (12/19/2007)

---

Dave, I believe that the 'MS OLE DB provider for ODBC drivers' 64-bit is available, its the Oracle ODBC RDB 64 bit drivers that are not yet...

Mike Seddon (12/19/2007)

---

Hi, I think I can help here.

1. Download the latest Oracle RDB ODBC driver from Oracle.

2. Create and configure your ODBC connection to the database in...

Hi Michael,

Yes I just asterixed the password out for the post.

I can't use SQL*Plus as the remote database is Oracle Rdb which is not

the standard Oracle...

From what I've read sp_repldone kills off all the publications/subscriptions so it's kind of an emergency measure. May come to this anyway as the logfile is growing at a...

Hi,

Can't detach the database because replication is enabled.

Looks like I may have to completely remove replication and then re-create a new log file.

Can't see any other...

Hi,

Replication is definately snapshot but the way it's used is slightly

non standard. Basically all the SQL agent jobs created by the replication

setup procedure are scripted and merged...

use [xps-2-sql]

go

checkpoint

backup log [xps-2-sql] with truncate_only

"The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or...

No sure if I'm following. There are no uncommited transactions in this database as

it's updated three times each evening in the small hours.

I can certainly do...

Not really sure although there's a good chance that is has been used to

'test' out different types of replication. Before this current setup went live

replication disabled/enabled....

Hi,

DBCC sqlperf(logspace) returns...

Database Logsize Log used %

XPS-2-SQL10667.6893.100380

backup log [xps-2-sql] with truncate_only

returns...

Yep seems like it. Both servers are going to move domain anyway but they will have to move at the same time.

Cheers

Dave