103 reputation
3
bio website
location
age
visits member for 3 years, 9 months
seen Jul 30 '12 at 18:02

Merge Keep


Sep
24
awarded  Autobiographer
Jun
22
awarded  Scholar
Jun
22
awarded  Editor
Jun
22
asked EXECUTE master.dbo.xp_delete_file folder permission issue
Mar
16
comment SQL Maintenance Cleanup Task Working but Not Deleting
@Joe Clark Could it be that the master.dbo.xp_delete_file is corrupt? I had an issue with this SQL install which is now fixed, see: serverfault.com/questions/244869/… Thank you for your help
Mar
16
comment SQL Maintenance Cleanup Task Working but Not Deleting
EXECUTE master.dbo.xp_delete_file 0,N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup',N'bak',N'2011-03-11T12:30:41',1
Mar
16
revised SQL Maintenance Cleanup Task Working but Not Deleting
edited tags
Mar
16
asked SQL Maintenance Cleanup Task Working but Not Deleting
Mar
14
accepted SSMS 2008 - Can't Add Maintenance Plans
Mar
10
revised SSMS 2008 - Can't Add Maintenance Plans
added 204 characters in body
Mar
10
comment SSMS 2008 - Can't Add Maintenance Plans
The maintance plan now creates .bak files but it seems I can't run MAINTENACE CLEANUP TASK. Could it be that master.dbo.xp_delete_file can't be found. Is there a way to reset that as well?
Mar
8
comment SSMS 2008 - Can't Add Maintenance Plans
That worked perfectly! Thanks @mrdenny
Mar
8
comment SSMS 2008 - Can't Add Maintenance Plans
I have SQL Server Integration Services 10.0 running on the machine.
Mar
8
comment SSMS 2008 - Can't Add Maintenance Plans
Under Integration Services I have Data Profile Viewer and Execute Package Utility. The server is missing Microsoft Analysis Services Client Tools component.
Mar
8
comment SSMS 2008 - Can't Add Maintenance Plans
I use to have an issue Deleting Jobs, I then added dbo.sp_delete_job under Databases > System Databases > msdb > Programmability > Stored Procedures - Deleting now works. Could my msdb be missing Stored Procedures? How do you go about fixing the msdb?
Mar
8
asked SSMS 2008 - Can't Add Maintenance Plans