DBCC CHECKDB: 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_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[5] Database HBLLC: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HBLLC\HBLLC_db_200506151939.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..
MattThis is a multi-part message in MIME format.
--080206070603060002020104
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Is 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_200506151939.BAK]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>[5] Database HBLLC: Database Backup...
> Destination: [E:\SQL Backups\Great
>Plains\Databases\HBLLC\HBLLC_db_200506151939.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
>
>
--080206070603060002020104
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Is 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?</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Matt Williamson wrote:
<blockquote cite="miduIb6VfgcFHA.616@.TK2MSFTNGP12.phx.gbl" type="cite">
<pre wrap="">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_200506151939.BAK]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[5] Database HBLLC: Database Backup...
Destination: [E:\SQL Backups\Great
Plains\Databases\HBLLC\HBLLC_db_200506151939.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
</pre>
</blockquote>
</body>
</html>
--080206070603060002020104--

Saturday, February 25, 2012

DB Maintenance Plan not backing up 2 databases..

No comments:

Post a Comment

DBCC CHECKDB

Blog Archive

About Me