BACKUP failed to complete the command maintenance plan

• msocp

  Say Hey Kid

  Points: 682

  More actions

  February 4, 2013 at 10:50 pm

  #288702

  Hi, Guys

  i schedule the backup using maintenance plan.

  Error is: 3041, severity: 16, state: 1

  Error message is:

  BACKUP failed to complete the command BACKUP DATABASE 'database_name' WITH DIFFERENTIAL

  i check the error log the same error is also given in the error log file.

  please give hints how to diagnose and resolved the error.

  1.backup taken to local storage

  2.SQL Maintenance plan

  3.SQL Server 2008 R2

  4.version: 10.50.4000

  regards

  Shafiq

• Andrew G

  SSChampion

  Points: 12809

  More actions

  February 5, 2013 at 12:52 am

  #1584196

  What message is in the history for the maintenance plan (right click, history)?

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  February 5, 2013 at 1:07 am

  #1584200

  Have you run a full backup at any time?

  Differential backups will only run if you've done a full backup, as they only back up changes made since the last full backup.

• msocp

  Say Hey Kid

  Points: 682

  More actions

  February 8, 2013 at 10:15 pm

  #1586200

  No,once a week full backup is executing.

  Thanks for reply.

  Shafiq