Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2005 Maintenance Plan Issues

Posted on 2008-10-17
6
Medium Priority
?
600 Views
Last Modified: 2013-11-10
Hello Everyone,

I am really hoping that someone will be able to help me here.. I am at my wits end and I can't figure out what the problem is.

I have created multiple Maintenance Packages (one for differential and one for full backups of all of my databases).  I have not altered the subplans that were created along with the packages.  The problem I am having is neither my Differential job NOR my Full backup job complete successfully.  The consistently fail with the following error:

Executed as user: FILE3\SYSTEM. ...rsion 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  3:58:35 PM  Progress: 2008-10-17 15:58:46.94     Source: {34269DD8-BCB9-4590-B079-B5446E21CDAC}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp".: 100% complete  End Progress  Progress: 2008-10-17 15:58:47.76     Source: Configuration Management Differential Backup      Executing query "BACKUP DATABASE [ConfigurationManagement] TO  DISK".: 100% complete  End Progress  Progress: 2008-10-17 15:58:49.32     Source: NetPerfMon Differential Backup      Executing query "BACKUP DATABASE [NetPerfMon] TO  DISK = N'D:\Datab".: 100% complete  End Progress  Progress: 2008-10-17 15:58:50.30     Source: ePO4_NMS1 Differential Backup      Executing query "BACKUP DATABASE [ePO4_NMS1] TO  DISK = N'D:\Databa".: 100% complete  End Progress  Progress: 2008-10-17 15:58:51.73     Source: SUSDB Differential Backup   ...  The package execution fa...  The step failed.

The database that the job will fail on will change from time to time (it seems that most of the time it is failing on the SUSDB though).  I have no idea why this database would be failing as I am able to successfully perform a manual backup of the ALL the databases using both the wizard and direct SQL Statements plugged into the query analyzer.

I have identical jobs set up at other locations for the exact same databases and I have NO problems whatsoever.  I have double checked the settings across a working site with the problem site and there are no differences in configuration.

If any one can help me or at least point me in the right direction I would be extremely Grateful.

Thank you all for you input and assistance.
0
Comment
Question by:chmilhouse
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 22760848
Would you check the Application Event Log?  Iirc, more information typically gets written there.

We've got to figure out WHY that one fails ... in my experience it's usually been due to disk space, but that doesn't really sound like the problem you're having.
0
 

Author Comment

by:chmilhouse
ID: 22760912
Hi Daniel,

Thank you for the reply.  I was actually able to track down the issue this morning.  One of the databases that was being backed up by this maintenance plan was located on a remote computer.  The user credentials entered to connect to that server were not correct and it was causing the jobs to fail.  I wasn't able to immediately notice this problem b/c the log I pasted above was pointing at a different database than the one that was causing the issue.  I am not 100% if there is a character limit on an SQL log file but would you happen to know?
0
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 22761065
>> I am not 100% if there is a character limit on an SQL log file but would you happen to know?

No ... I'm not sure on that.
0
 

Author Comment

by:chmilhouse
ID: 22761863
Ok.  Thanks for the help Daniel.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 23022695
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

688 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