maintenance plan reports delete backup file fail but deletes it ok

Hi
I have a sql 2000 sp4 maintenance plan that is set to delete old dbs
over 2 days old. In the maintenance plan history it reports this
activity failing for one db, but the Message section reports 1 file
deleted. The transaction log backup delete works ok and reports
correctly. Any ideas?
KevHey Kev,
(Don'cha hate it when no one replies to your question') :-)
Even though the History states failure, does the physical file actually get
deleted, though? I've seen several times the "work" gets done even though
sqlmaint (for some reason) has problems and fails. I've never really paid
much attention to the History, myself. Maybe I should. But I always
right-click on the job (if it show failure) and check the jobsteps. Then, I
check the output file created by the Plan's job (backup, optimization, etc.).
Could you send the few lines of output from both the History (may need to
manually type) and the Message section of the output? Manybe I can see
something from them.
Thanks
TJ
"nsiadmin" wrote:
> Hi
> I have a sql 2000 sp4 maintenance plan that is set to delete old dbs
> over 2 days old. In the maintenance plan history it reports this
> activity failing for one db, but the Message section reports 1 file
> deleted. The transaction log backup delete works ok and reports
> correctly. Any ideas?
> Kev
>|||On 21 Mar, 14:50, ToeJam <Toe...@.discussions.microsoft.com> wrote:
> Hey Kev,
> (Don'cha hate it when no one replies to your question') :-)
> Even though the History states failure, does the physical file actually get
> deleted, though? I've seen several times the "work" gets done even though
> sqlmaint (for some reason) has problems and fails. I've never really paid
> much attention to the History, myself. Maybe I should. But I always
> right-click on the job (if it show failure) and check the jobsteps. Then, I
> check the output file created by the Plan's job (backup, optimization, etc.).
> Could you send the few lines of output from both the History (may need to
> manually type) and the Message section of the output? Manybe I can see
> something from them.
> Thanks
> TJ
> "nsiadmin" wrote:
> > Hi
> > I have a sql 2000 sp4 maintenance plan that is set to delete old dbs
> > over 2 days old. In the maintenance plan history it reports this
> > activity failing for one db, but the Message section reports 1 file
> > deleted. The transaction log backup delete works ok and reports
> > correctly. Any ideas?
> > Kev
Hi TJ
thanks for your reply.
this is the log file from the maint job :
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server 'MHA-SQL01\SQL01' as 'MHACAREGROUP\CLU01SQLSVC' (trusted)
Starting maintenance plan 'MHA CareG1_SITE Mtnce plan' on 19/03/2007
20:00:02
[1] Database MHACareG1_SITE: Transaction Log Backup...
Destination: [G:\Program Files\Microsoft SQL Server\MSSQL
$SQL01\BACKUP\MHACareG1_SITE\MHACareG1_SITE_tlog_200703192000.TRN]
** Execution Time: 0 hrs, 0 mins, 9 secs **
[2] Database MHACareG1_SITE: Delete Old Backup Files...
2 file(s) deleted.
Deleting old text reports... 1 file(s) deleted.
End of maintenance plan 'MHA CareG1_SITE Mtnce plan' on 19/03/2007
20:00:11
SQLMAINT.EXE Process Exit Code: 0 (Success)
yet the maintenance plan history records :
Db Activity Status
End date Message
MHACareG1_site Delete old db backups X 19/03/07 20:31
2 files deleted
so it appears to do exactly what it says, but still reports it as
failed.
I am going to set up a new maint plan for this db to a different
folder with exactly the same details
Kev|||That is interesting, not to mention odd.
Question; What else does this Maint. Plan do besides the TLog backup?
The job output states that the job (or step?) begins @. 20:00:02 and finishes
@. 20:00:11 (Execution Time: 9 secs). BUT, the History record shows the End
date (time) as 20:31. What else occurred within those 31 minutes? A
Database Backup, or an Optimization perhaps? Maybe it was one of those that
actually failed. Or are there any other Steps within the same Job?
TJ
"nsiadmin" wrote:
> On 21 Mar, 14:50, ToeJam <Toe...@.discussions.microsoft.com> wrote:
> > Hey Kev,
> >
> > (Don'cha hate it when no one replies to your question') :-)
> >
> > Even though the History states failure, does the physical file actually get
> > deleted, though? I've seen several times the "work" gets done even though
> > sqlmaint (for some reason) has problems and fails. I've never really paid
> > much attention to the History, myself. Maybe I should. But I always
> > right-click on the job (if it show failure) and check the jobsteps. Then, I
> > check the output file created by the Plan's job (backup, optimization, etc.).
> >
> > Could you send the few lines of output from both the History (may need to
> > manually type) and the Message section of the output? Manybe I can see
> > something from them.
> > Thanks
> > TJ
> >
> > "nsiadmin" wrote:
> > > Hi
> >
> > > I have a sql 2000 sp4 maintenance plan that is set to delete old dbs
> > > over 2 days old. In the maintenance plan history it reports this
> > > activity failing for one db, but the Message section reports 1 file
> > > deleted. The transaction log backup delete works ok and reports
> > > correctly. Any ideas?
> >
> > > Kev
> Hi TJ
> thanks for your reply.
> this is the log file from the maint job :
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
> Server 'MHA-SQL01\SQL01' as 'MHACAREGROUP\CLU01SQLSVC' (trusted)
> Starting maintenance plan 'MHA CareG1_SITE Mtnce plan' on 19/03/2007
> 20:00:02
> [1] Database MHACareG1_SITE: Transaction Log Backup...
> Destination: [G:\Program Files\Microsoft SQL Server\MSSQL
> $SQL01\BACKUP\MHACareG1_SITE\MHACareG1_SITE_tlog_200703192000.TRN]
> ** Execution Time: 0 hrs, 0 mins, 9 secs **
> [2] Database MHACareG1_SITE: Delete Old Backup Files...
> 2 file(s) deleted.
> Deleting old text reports... 1 file(s) deleted.
> End of maintenance plan 'MHA CareG1_SITE Mtnce plan' on 19/03/2007
> 20:00:11
> SQLMAINT.EXE Process Exit Code: 0 (Success)
> yet the maintenance plan history records :
> Db Activity Status End date Message
> MHACareG1_site Delete old db backups X 19/03/07 20:31 2 files deleted
> so it appears to do exactly what it says, but still reports it as
> failed.
> I am going to set up a new maint plan for this db to a different
> folder with exactly the same details
> Kev
>|||Hi Tj,
yes it does a db backup which works ok. The History record refers only
to the delete old files part of the job which ran at 20:31. All the
steps within the maint job are listed in the history as separate
activities, but only delete old files step fails.
Interestingly I set up the new job to run overnight, created 2 old
files in the destination folder, and everything worked ok.
Sometimes I guess its easier to just start again and forget it.
Cheers
Kev
On 21 Mar, 16:18, ToeJam <Toe...@.discussions.microsoft.com> wrote:
> That is interesting, not to mention odd.
> Question; What else does this Maint. Plan do besides the TLog backup?
> The job output states that the job (or step?) begins @. 20:00:02 and finishes
> @. 20:00:11 (Execution Time: 9 secs). BUT, the History record shows the End
> date (time) as 20:31. What else occurred within those 31 minutes? A
> Database Backup, or an Optimization perhaps? Maybe it was one of those that
> actually failed. Or are there any other Steps within the same Job?
> TJ
> "nsiadmin" wrote:
> > On 21 Mar, 14:50, ToeJam <Toe...@.discussions.microsoft.com> wrote:
> > > Hey Kev,
> > > (Don'cha hate it when no one replies to your question') :-)
> > > Even though the History states failure, does the physical file actually get
> > > deleted, though? I've seen several times the "work" gets done even though
> > > sqlmaint (for some reason) has problems and fails. I've never really paid
> > > much attention to the History, myself. Maybe I should. But I always
> > > right-click on the job (if it show failure) and check the jobsteps. Then, I
> > > check the output file created by the Plan's job (backup, optimization, etc.).
> > > Could you send the few lines of output from both the History (may need to
> > > manually type) and the Message section of the output? Manybe I can see
> > > something from them.
> > > Thanks
> > > TJ
> > > "nsiadmin" wrote:
> > > > Hi
> > > > I have a sql 2000 sp4 maintenance plan that is set to delete old dbs
> > > > over 2 days old. In the maintenance plan history it reports this
> > > > activity failing for one db, but the Message section reports 1 file
> > > > deleted. The transaction log backup delete works ok and reports
> > > > correctly. Any ideas?
> > > > Kev
> > Hi TJ
> > thanks for your reply.
> > this is the log file from the maint job :
> > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
> > Server 'MHA-SQL01\SQL01' as 'MHACAREGROUP\CLU01SQLSVC' (trusted)
> > Starting maintenance plan 'MHA CareG1_SITE Mtnce plan' on 19/03/2007
> > 20:00:02
> > [1] Database MHACareG1_SITE: Transaction Log Backup...
> > Destination: [G:\Program Files\Microsoft SQL Server\MSSQL
> > $SQL01\BACKUP\MHACareG1_SITE\MHACareG1_SITE_tlog_200703192000.TRN]
> > ** Execution Time: 0 hrs, 0 mins, 9 secs **
> > [2] Database MHACareG1_SITE: Delete Old Backup Files...
> > 2 file(s) deleted.
> > Deleting old text reports... 1 file(s) deleted.
> > End of maintenance plan 'MHA CareG1_SITE Mtnce plan' on 19/03/2007
> > 20:00:11
> > SQLMAINT.EXE Process Exit Code: 0 (Success)
> > yet the maintenance plan history records :
> > Db Activity Status End date Message
> > MHACareG1_site Delete old db backups X 19/03/07 20:31 2 files deleted
> > so it appears to do exactly what it says, but still reports it as
> > failed.
> > I am going to set up a new maint plan for this db to a different
> > folder with exactly the same details
> > Kev