ODBC error when I tried to backup database (SQL2000 SP3)

I used function backup on Navision 4.0 (SQL2000 SP3) and then this error (“Error: [Microsoft][ODBC SQL Server Driver]Operation invalid at this time State ID: HY011”) showed on my screen. My labtop’s not response.

Please give me any suggestion.


Hi “sunrise4all”!

Welcome to the “Dynamics User Group” [<:o)]

So, if I understood this correctly, you receve this error when trying to create a backup with NAV inbuilt feature? Which user rights do you have on the SQL Server? Have you tried to backup with “db_owner” or “sysadmin” rights?

But anyway, I strongly recommend to NOT use the NAV site feature; backups can be created smarter, faster and more reliable with the SQL site methods!

Best regards,