How can we help you today? How can we help you today?

Backup Error

I have been creating backup plans for several servers. On one server I get the following error:

SQL Backup failed with exit code: 586 SQL error code: -1 [SQLSTATE 42000] (Error 50000). The step failed.

I get this error whether the backup runs from the job or manually. However, if I remote to the server and run a backup from the command line, it works fine.

From what I can tell, the setup is identical to the other servers that are working fine.

Additionally, I am supposed to get an email if the job fails and I am not, although the test email worked.
cpoul
0

Comments

3 comments

Sort by
  • petey
    Could you post the contents of the log file for the failed task? The default folder for log files is <system drive>\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>

    Look for a file that does not have a GUID value around the same time the job ran, as that would indicate that the backup/restore process failed.

    Thanks.
    petey
    0
  • cpoul
    The error message is:
    SQL Backup log file 5.2.0.2825
    SQL error -2147467259: Cannot generate SSPI context
    SQL error -2146893044: SQL Network Interfaces: The logon attempt failed

    Server : VTES01
    Windows authentication
    11/28/2007 10:13:18 AM: Failed to connect to SQL Server instance: VTES01
    cpoul
    0
  • petey
    Is the server name correct? Also, if you run a backup using Query Analyzer or Management Studio eg.
    EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = &#91;&lt;auto&gt;&#93;"'
    Does it generate the same error?

    Thanks.
    petey
    0

Add comment

Please sign in to leave a comment.