DB Maintenance Plan not backing up 2 databases..

I have a DB Maintenance plan that runs and indicates success and shows
nothing in the log, but doesn't ever write the backup file to disk. This is
happening for 2 out of 3 databases that are backed up in this plan. All
databases are set to Full recovery mode and I can back all of them up
manually without a problem. I also use BackupExec with the SQL agent and it
works fine. I've been searching the archives looking for anything along
these lines, but I haven't found anything yet. Here is some additional
environment info in case it makes any difference.
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on
Windows NT 5.2 (Build 3790
Snip from Log Output:
[4] Database DYNAMICS: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\DYNAMICS\DYNAMICS_db_20
0506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[5] Database HBLLC: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HBLLC\HBLLC_db_20050615
1939.BAK]
** Execution Time: 0 hrs, 0 mins, 3 secs **
[6] Database HCB: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HCB\HCB_db_200506151939
.BAK]
** Execution Time: 0 hrs, 0 mins, 7 secs **
I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
to create subfolders. If I delete the HCB and HCBLLC folders, it does
re-create them. I currently have the SQL Agent running from a domain level
admin account (temporarily for testing) to rule out any possible rights
issues.
I'm stumped.. any Help would be appreciated..
MattIs there anything in the SQL errorlog or NT Event log (normally
Application log) that corresponds with the DB maint plan execution times
that may shed some light on the problem? Is E: a mapped network drive
or a local volume? Have you tried creating a new maint plan for one of
the problem DBs on its own?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Matt Williamson wrote:

>I have a DB Maintenance plan that runs and indicates success and shows
>nothing in the log, but doesn't ever write the backup file to disk. This is
>happening for 2 out of 3 databases that are backed up in this plan. All
>databases are set to Full recovery mode and I can back all of them up
>manually without a problem. I also use BackupExec with the SQL agent and it
>works fine. I've been searching the archives looking for anything along
>these lines, but I haven't found anything yet. Here is some additional
>environment info in case it makes any difference.
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on
>Windows NT 5.2 (Build 3790
>Snip from Log Output:
>
>[4] Database DYNAMICS: Database Backup...
> Destination: [E:\SQL Backups\Great
> Plains\Databases\DYNAMICS\DYNAMICS_db_20
0506151939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>[5] Database HBLLC: Database Backup...
> Destination: [E:\SQL Backups\Great
> Plains\Databases\HBLLC\HBLLC_db_20050615
1939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 3 secs **
>[6] Database HCB: Database Backup...
> Destination: [E:\SQL Backups\Great
> Plains\Databases\HCB\HCB_db_200506151939
.BAK]
> ** Execution Time: 0 hrs, 0 mins, 7 secs **
>
>I have it set to write backups to E:\SQL Backups\Great Plains\Databases and
>to create subfolders. If I delete the HCB and HCBLLC folders, it does
>re-create them. I currently have the SQL Agent running from a domain level
>admin account (temporarily for testing) to rule out any possible rights
>issues.
>I'm stumped.. any Help would be appreciated..
>Matt
>
>