Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobias
The path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobiasThe path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

sql

Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobiasThe path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobiasThe path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

Maintanance Plan

in the beginning i could create such plans without any problem, but since the workstations run's inside domain it doesn't work either with sa nor with system admin.

any idea how i can solve that issue? below you find the details of the exception i get.

thanks in advance,

===================================

Exception has been thrown by the target of an invocation. (mscorlib)

Program Location:

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetExistingPackageNames(String serverName, String userName, SqlSecureString securePassword)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()

===================================

An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

===================================

An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

kind regards,

roni schuetz

Are you trying to execute these in code? or is this some unhandled exception you're getting back from the UI.

Otherwise try looking at the History of the jobs in question. You can right click on the maintenance plans node and view the history from within Management Studio.

--Mike|||

that is what i receive from the UI when i try to create a job

|||I have the same exact problem .... any suggestions on how to fix this issue? Thanks!|||

To resolve this problem, install the SSIS service
1. After the System Configuration Check is complete, click Next.
2. Enter a Name, enter a Company, and then click Next.
3. Click the Integration Services check box, and then click Next.
4. Click Next, and then click Install.
5. When the installation is complete, click Next, and then click Finish.

SQL Server Integration Services (SSIS)
http://msdn2.microsoft.com/en-us/library/ms141026.aspx
How to create a Maintenance Plan
http://msdn2.microsoft.com/en-us/library/ms189953.aspx

Thanks

|||

We already have installed SSIS service. Still having the same issue?

Dev

|||

I got this solution from Google groups.

1. Go to C:\Documents and Settings\"sql startup account"\Application
Data\Microsoft\Crypto\RSA\S-1-5-21......
(where "sql startup account" should be the name of your startup account
for sql server")

2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
don't delete the folder)

3. Restart SQL Server.

Maintanance Plan

in the beginning i could create such plans without any problem, but since the workstations run's inside domain it doesn't work either with sa nor with system admin.

any idea how i can solve that issue? below you find the details of the exception i get.

thanks in advance,

===================================

Exception has been thrown by the target of an invocation. (mscorlib)

Program Location:

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetExistingPackageNames(String serverName, String userName, SqlSecureString securePassword)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()

===================================

An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

===================================

An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

kind regards,

roni schuetz

Are you trying to execute these in code? or is this some unhandled exception you're getting back from the UI.

Otherwise try looking at the History of the jobs in question. You can right click on the maintenance plans node and view the history from within Management Studio.

--Mike
|||

that is what i receive from the UI when i try to create a job

|||I have the same exact problem .... any suggestions on how to fix this issue? Thanks!|||

To resolve this problem, install the SSIS service
1. After the System Configuration Check is complete, click Next.
2. Enter a Name, enter a Company, and then click Next.
3. Click the Integration Services check box, and then click Next.
4. Click Next, and then click Install.
5. When the installation is complete, click Next, and then click Finish.

SQL Server Integration Services (SSIS)
http://msdn2.microsoft.com/en-us/library/ms141026.aspx
How to create a Maintenance Plan
http://msdn2.microsoft.com/en-us/library/ms189953.aspx

Thanks

|||

We already have installed SSIS service. Still having the same issue?

Dev

|||

I got this solution from Google groups.

1. Go to C:\Documents and Settings\"sql startup account"\Application
Data\Microsoft\Crypto\RSA\S-1-5-21......
(where "sql startup account" should be the name of your startup account
for sql server")

2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
don't delete the folder)

3. Restart SQL Server.

Maintanance job fails

EXECUTE master.dbo.xp_sqlmaint N'-PlanID
95C0459D-8D08-478E-9058-41CA9D0A0F51 -Rpt
"P:\SQLBackup\AllUserDB0.txt" -DelTxtRpt 2WEEKS -WriteHistory
-RebldIdx 10 -RmUnusedSpace 50 10 '
results in www.planprojekt.dk/upload/maint.txt, where the end of the
file states
"SQLMAINT.EXE Process Exit Code: 1 (Failed)"
The error log shows nothing. Only thing left is the report created by
the job. The repo is the one shown in the link above.
So I'm finding it difficult to get to the core of the failure - any
help is greatly appreciated.
Thx in advance.
Regards /SnedkerOn Tue, 14 Mar 2006 10:29:31 +0100, Morten Snedker
<morten_spammenot_ATdbconsult.dk> wrote:
First of all, sorry for posting same message twice - my mistake.
Secondly, there IS an error in the report, where I try to maintanance
a read-only-database. :-)
/Snedker

>EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>95C0459D-8D08-478E-9058-41CA9D0A0F51 -Rpt
>"P:\SQLBackup\AllUserDB0.txt" -DelTxtRpt 2WEEKS -WriteHistory
>-RebldIdx 10 -RmUnusedSpace 50 10 '
>results in www.planprojekt.dk/upload/maint.txt, where the end of the
>file states
>"SQLMAINT.EXE Process Exit Code: 1 (Failed)"
>The error log shows nothing. Only thing left is the report created by
>the job. The repo is the one shown in the link above.
>So I'm finding it difficult to get to the core of the failure - any
>help is greatly appreciated.
>Thx in advance.
>
>Regards /Snedker