SQL backup job error

Hello:

In SQL 2005 9.0.3054, I have a very simple maintenance plan that is to
backup five databases each night. It fails to do so.

It backs up three of the databases but, consistently, there are two that do
not get backed up.

The following are the error messages that I keep getting:
Error: 18204, Severity: 16, State: 1.
Operating system error 3(The system cannot find the path specified.).
Error: 3041, Severity: 16, State: 1.
Check the backup application log for detailed messages.

It is a simple backup job that is backing up to its own local drive! I
don't understand why it "cannot find the path".

The Event Viewer, as usual, is telling me nothing other than that the backup
job has failed.

I did not create this plan with the wizard. I just dragged the icons over.

This plan is to make a full backup of the databases. The databases were set
up at about the same time and similarly. I don't know why two are failing to
be backed up.

Any ideas?

SQL Programmer (it's just a name)
.

Relevant Pages

  • Re: Sharepoint DB maintenance?
    ... options to backup nightly. ... I am more concerned abouthe maintenance (i.e. SQL maintenance?) stuff. ... It's a good idea to back up the SPS databases regularly. ... on the server that is running SQL Server 2000." ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Problem with Transaction backups
    ... You always need to do a FULL backup before you can issue Log backups otherwise there is nothing for the log chain to initialize to. ... Andrew J. Kelly SQL MVP ... SQL Y2K5 SP3 shutdown the WindowsXP SP2 test machine with a blue screen. ... In the maintenance plan logs the backups, ...
    (microsoft.public.sqlserver.server)
  • Re: How do I upgrade/migrate from SQL 2000 (not MSDE) to SQL 2005?
    ... PORTAL SERVER DATA BACKUP ... Be sure to save a complete and full backup using SharePoint's Backup ... BACKUP SQL 2000 DATABASES DIRECTLY THROUGH SQL ...
    (microsoft.public.sharepoint.portalserver)
  • Re: how to skip failed backup command?
    ... If you do not specify WITH INIT for the other two databases, ... backups will be appended to your backup device file. ... Looking for a SQL Server replication book? ... bing wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: SQL SERVER 2005 x64 SP3 and Windows Server 2008 R2 X64
    ... So it shows you the sql icons to represent the database. ... sure there isn't a SQL Agent job that is actually doing the backup. ... and log folders are on two seperate mount points. ... SQL databases were successfully backed up. ...
    (microsoft.public.sqlserver.setup)