i have 2 SQL servers (Development & Production) both have the same scheduled backup job (contains 35 databases). However, on the development server after the job finish i find that there are 2 databases failed to backup and the following error message is there:
Executed as user: NT AUTHORITY\SYSTEM. Write on ‘DBFLog’ failed, status = 112. See the SQL Server error log for more details. [SQL STATE 42000] (Error 3202) BACKUP LOG is terminating abnormally. [SQL STATE 42000] (Error 3013). The step failed.
i do the backup to a backup device whiche i created on the same server. The server has enough space, and when i do the job manually it works fine.
any ideas...
Thankx