Maintanance clean up task doen not delete transaction logs in 2008

Question

Post reply

Maintanance clean up task doen not delete transaction logs in 2008

kk3

Grasshopper

Points: 21
More actions
April 29, 2010 at 9:41 am

#386818

Hi All,
I have a SSIS jobs to
1) backup databases ---> daily works fine
2) backup transaction logs --> for every four hors works fine
3) delete backup --> once a day sysdate-1 wirks fine
4) delete transaction logs -- once a day sysdate-1 " doen not work at all"
I dont why,
I am setting up some thing wrong
i have tried to google, and specify the exact file but still nothing works
Any help please
cheers
kalyan

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

kk3 Grasshopper Points: 21 More actions · Answer 1

TSQL from the jobs is

EXECUTE master.dbo.xp_delete_file 1,N'F:\DBATEST',N'.trn',N'2010-04-27T16:56:20',1

cheers

kalyan

Jeffrey Williams SSC Guru Points: 90351 More actions · Answer 2

kk3 (4/29/2010)
TSQL from the jobs is
EXECUTE master.dbo.xp_delete_file 1,N'F:\DBATEST',N'.trn',N'2010-04-27T16:56:20',1
cheers
kalyan

Remove the . in the extension parameter. If you compare the above with the one that is working, you'll see the one that is working does not have the period.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

kk3 Grasshopper Points: 21 More actions · Answer 3

Hi All,

Thanks for your reply,

I have removed "." from the file extension but still it doesn't delete any files

but the job logs say it ran successfully

here the out put from the job

Date30/04/2010 10:15:42

LogJob History (Backup Databases.delete trasanction logs)

Step ID1

ServerMSSQLDEV2\DBATEST

Job NameBackup Databases.delete trasanction logs

Step Namedelete trasanction logs

Duration00:01:05

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: MSSQLDEV2\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:15:43 Progress: 2010-04-30 10:16:15.73 Source: {D7376CED-8C63-4172-9A5C-FCC84484CA7A} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2010-04-30 10:16:42.60 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 1,N'F:\DBATEST',...".: 100% complete End Progress DTExec: The package execution returned DTSER_SUCCESS (0). Started: 10:15:43 Finished: 10:16:46 Elapsed: 62.985 seconds. The package executed successfully. The step succeeded.

Jeffrey Williams SSC Guru Points: 90351 More actions · Answer 4

Validate the folder location and whether or not you have checked the box to create a folder for each database. If that box is checked for the backups, the cleanup task also has to be set to look in the sub-folders.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs