Error when job runs: The server principal "DB-SERVER\Administrator" is not able to access the database

Thanks for the reply, a good thought but unfortunatly didn't help. A colleugue noticed this morning that the service was running with the wrong privs. we reset it to Local System Account, all working as it should now.

Start > Run > Services.msc > 'SQL Server agent (TESTDB)' > Double Click > Log On > Local System Account.