Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

.BAK file not deleted by Management plan Clean-up task schedule? Expand / Collapse
Author
Message
Posted Tuesday, August 26, 2014 1:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:55 PM
Points: 1,076, Visits: 3,054

Backup files are not deleted by automatically, but as per backup logs Cleanup task working without any errors.

I have verified that server side,
1. Event viewer - there is no errors
2. Error log - there is no errors
3. Job (SQL Server Agent > Jobs), job running under windows authentication

Executed manually as below command that also working without any errors, why that backup files are not deleted? If anyone facing same issues or how to fix it?

Maintenance Cleanup on Local server connection
Cleanup Database Backup files
Age: Older than 5 Days
Task start: 2014-08-26T00:00:30.
Task end: 2014-08-26T00:00:50.
Success
Command:EXECUTE master.dbo.xp_delete_file 0,N''E:\SQL_DB_Backup\Full_Backup'',N''bak'',N''2014-08-21T00:00:30'',1
Post #1607358
Posted Tuesday, August 26, 2014 3:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 15, 2014 10:41 PM
Points: 177, Visits: 257
As far as I know the problem might be of permissions. Please check and verify.
Post #1607389
Posted Tuesday, August 26, 2014 10:32 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:55 PM
Points: 1,076, Visits: 3,054

For the permission issues, where should i check at server side?

SQL Engine and Agent service running under Network service account.

Does Backup folder need to check? but this folder NT Service account not avilable at seurity tap.

Post #1607655
Posted Wednesday, August 27, 2014 12:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:04 AM
Points: 44, Visits: 98
What is the id that the job is set up to RUN AS and what are the roles/permissions for that id?
Post #1607993
Posted Wednesday, August 27, 2014 1:15 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:55 PM
Points: 1,076, Visits: 3,054
That backup job run at under owner of 'servername\Administrator'
Post #1607999
Posted Friday, August 29, 2014 8:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:04 AM
Points: 44, Visits: 98
What is the server role and permission for that id?
Post #1608637
Posted Friday, August 29, 2014 10:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 15, 2014 10:41 PM
Points: 177, Visits: 257
Please check this blog here might be helpful.
Post #1608802
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse