Check the advanced editor on the data source properties for input and output columns...these are often defined by a sample of data and could well be wrong, check each one,...

Have to say we did have seemingly random errors on backups when backing up to a network drive. After lots of searching we put them down to network blips!

You do need permissions to the folders, also, are you using the full UNC path for the folders?

I use these (from brentozar.com) and then add others if and when the need arises.

•Memory – Available MBytes

•Paging File – % Usage

•Physical Disk – Avg. Disk sec/Read

...

Thanks both for the replies as always.

Perhaps I recall wrong Gail, I come to have more and more mistrust in my memory each day! It didnt seem a good...

Dare I say it, could you not use the import/export wizard?

I would check if server 2 (the subscriber) has visibility of server 1 that way.

Looks like there's something inbetween that just hasnt worked, its not replication specific per...

OK, thats fine, in that case can you right click and test connection on it?

Ah right, no worries.

If you go under Server Objects you will see the option for the new linked server, basically set it up with the sql credentials you are using...

Have you restored to a test server and ran CHECKDB on the restored database?

So when you are on chatsql, you go to replication, local subscriptions...new subscription wizard and put in the servsql in the connect box, thats where the error occurs? And...

Just out of interest, from management studio on server B what do you get when you type

SELECT @@SERVERNAME is it the expected?

Well of course that depends what you are doing!

I was just double checking that server A can connect to server B directly, I know you can access server B...

May I ask, are you connecting to server 2 with windows or sql authentication? Can you set up a linked server on server 1 to the subscription server with...

Absolutely, I never use sa unless its a in case of emergency etc...

However I would necessarily use a service account for an owner, rather I was saying the Agent jobs...