Re: Error with simple maintenance plan
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 23 Mar 2008 16:05:38 -0700
aaron.kempf@xxxxxxxxx (aaron.kempf@xxxxxxxxx) writes:
I've been getting nothing but errors recently; as I've been usign
maintenance plans.
Here is one of the error logs.
Executing the query "EXECUTE master.dbo.xp_delete_file
0,N'',N'',N'2008-03-14T00:56:18'
" failed with the following error: "Error executing extended stored
procedure: Invalid Parameter". Possible failure reasons: Problems with
the query, "ResultSet" property not set correctly, parameters not set
correctly, or connection not established correctly.
The cause for the error message is obvious: there is no file name.
So, as for why there is not, I don't know. I avoid maintenance plans as
much as I can.
But people who have more experience and who want to help you, may be
interested in which version of SQL Server you are using, so please post
the output of SELECT @@version.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Error with simple maintenance plan
- From: aaron.kempf@xxxxxxxxx
- Error with simple maintenance plan
- Prev by Date: Error with simple maintenance plan
- Next by Date: Enterprise manager missing in SQL2005
- Previous by thread: Error with simple maintenance plan
- Next by thread: Enterprise manager missing in SQL2005
- Index(es):
Relevant Pages
|
Loading
