Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BACKUP failed to complete the command maintenance plan Expand / Collapse
Author
Message
Posted Monday, February 4, 2013 10:50 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 11, 2013 1:14 AM
Points: 20, Visits: 260
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
Post #1415575
Posted Tuesday, February 5, 2013 12:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:49 PM
Points: 1,237, Visits: 1,719
What message is in the history for the maintenance plan (right click, history)?
Post #1415618
Posted Tuesday, February 5, 2013 1:07 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:19 AM
Points: 1,307, Visits: 4,508
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.



Post #1415624
Posted Friday, February 8, 2013 10:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 11, 2013 1:14 AM
Points: 20, Visits: 260
No,once a week full backup is executing.

Thanks for reply.
Shafiq
Post #1417976
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse