That's what concerns me too. a tlog backup every 5-10 minutes isn't enough sometimes. Not to mention the serverload and IO it's costing.

At the moment I'm trying a different approach....

coorect me if i'm wrong, but does the script not doing that job?

because that's what the script should do.

BACKUP LOG INFOPROD

TO DISK = N'D:\MSSQL\BACKUP\INFOPROD_tran.bak'

WITH NOINIT , NOUNLOAD , NAME =...

@SQLBill

The orders are done manually ( just salesorders )

over a period of the day. some orders are completed in a single entry, others are changed at backoffice

but...

When using Access frontend you can send "Pass Through" Queries directly to SQL Server.

http://support.microsoft.com/?kbid=303968

Don't know is you are using MS Word for Mail Merge, but then it's also...