Post reply

Error: 3041, Severity: 16, State: 1.BACKUP failed...

  • June 28, 2012 at 7:48 am

    #262910

    Hi Guys ..

    I am working on to solve this error

    "Error: 3041, Severity: 16, State: 1 BACKUP failed to complete the command BACKUP DATABASE<DB_NAME> WITH DIFFERENTIAL. Check the backup application log for detailed messages."

    - I have already full back up of database but somehow got failed today early morning.

    checked the event viewer also saying same check the backup application log.

    So how to check backup application log?

    Or any idea to solve this prob.

    Many thanks in advance

  • June 28, 2012 at 8:41 am

    #1506653

    Normally the backup application log refers to the calling application that started the BACKUP command. For example, if you're using SSIS Maintenance Plans and SQL Server Agent Jobs, check the job history and drill down from there. If you're using a scripted solution or third-party app, check the error logs for the app.

    First things to check - available disk/tape space, jobs scheduled for the same time as the backup, size of database files (.mdf, .ldf, .ndf). Permissions on folders. Then rerun the backup manually, see if it succeeds. If it doesn't, diagnose the error message from your ad-hoc run and find the issue from there.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

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

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