Post reply

backup job fails with this error.

  • May 8, 2015 at 9:40 am

    #318080

    Hi,

    I have SQL Server 2008, R2 and 2012 SQL Servers where my automated backup job is failing due to the below error.

    Do I need to add "With Format" at the end of my backup db statement, as mentioned in the article?

    https://support.microsoft.com/en-us/kb/290787

    But, noted that the article does not talk about issues with SQL 2012 ..

    PLEASE suggest.

    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    (null)

    Error 3013, Severity 16, State 1, Procedure -, Line 1 [SQLSTATE 01000]

    BACKUP DATABASE is terminating abnormally. [SQLSTATE 01000]

    NULL

    Thanks.

  • May 8, 2015 at 9:58 am

    #1796636

    I think it would help if you posted the backup statement you're running.

    Obfuscate anything you think needs to be like file and path names, but leave all the options etc as-is.

    Otherwise, it's just guessing on everyone's part.

  • May 8, 2015 at 10:16 am

    #1796646

    Thanks . Attached my backup script.

    note: just added the FORMAT keywords. When the failures were reported, I did have the WITH INIT one, (no FORMAT)

    Thanks.

  • May 8, 2015 at 11:31 am

    #1796681

    Don't see the attachment.

  • May 8, 2015 at 11:46 am

    #1796687

    Sorry Fellas. Please find attached.

    I tried to attach the .SQL file, which it did not allow to upload. So missed. Thanks Steve!!!

    Thanks.

  • May 8, 2015 at 2:00 pm

    #1796719

    Print the SQL statement and see what is actual backup statement is that is failing. From looking at the code alone doesn't really help.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply