I get nothing returned when I run that query.

Should there be a log reader agent for snapshot replication?

Well its a snapshot replication we have setup does the same reasoning apply?

Its in Full recover mode and we are doing hourly log backups which are still working. Its interesting that you mention replication as we recently setup a snapshot replication,...

ok seems the distrib.exe should only run when its need to call the job. The problem was in a post snapshot script.

Ok I have setup the subscription to run in continous mode however not sure what is happpening as this was working but now isn't. The Distrib.exe is not running...

HI thanks for the reply. I think I need more basic help than this, how do I populate the variable?

Sorted it - was me not reading the field properly, I was including the root path when I didn't need to.

Amazingly I seem to have got so far in getting this to work using an FTP server, this is all locally at the moment. I used a Domain account...

unfortunately no trust between domains. In an effort to reduce pressure on the publisher we are running the snapshot on a remote distributor.

Try logging onto that instance with a administrator account and seeing if the account you are using exists and has correct permissions.

If thats the case, what account did you use to access your snapshot share folder?

Well the SPID related to a motnthly job that is used to start a procedure to populate some "snapshot" tables. I had to stop the job.

Hi sorry for the slow response to this.

The indexes I am talking about currently only have row level locking enabled i.e. not page locking. My understanding is that the...

In the end I had to delete the subscription from the ReportServer database.

😀 so are you saying I should maybe change the min server memory to 1GB? Oh this is 32bit without AWE implemented.