Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server Full backup maintenance plan reports failure, yet log shows success

Posted on 2014-02-10
4
Medium Priority
?
755 Views
Last Modified: 2014-02-13
I have a SQL Server 2005 maintenance plan that does full backups of all databases. It had been working flawlessly until recently.

I changed the location where it writes the backup images. From then on, I get an email notification that the backups failed.

When I check on the status of the backups, they all were successful.  The maintenance plan does the following:
 DBCC CHECKDB on each database (system and user)
 Cleanup job
 Full backup of each database
 Backup transaction logs (of databases in FULL recovery mode)
 
I think it is related to the cleanup task. Yet its history shows that it completed successfully.
What's going on here? Should I disable or remove the cleanup task from the maintenance plan?

TIA!
0
Comment
Question by:data_bits
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
dannygonzalez09 earned 2000 total points
ID: 39847581
Not the best of the solutions but when i had a similar problem before after trying several different things which did not work, i deleted and re created the tasks and the job and everything worked fine
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39849063
Should I disable or remove the cleanup task from the maintenance plan?
What does the cleanup task actually do?
0
 

Author Comment

by:data_bits
ID: 39850095
The cleanup task goes through and deletes .bak and ,trn files older than 14 days. It also purges the history file of things of the same age.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39852083
Then I am afraid I have no idea.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question