hi there.
i'm setting up a db maintenance plan (running windows 2000). but when i run the jobs, it fails i get the following message in job history:
"sqlmaint.exe failed. [SQLSTATE 42000][Error 22029]. The step failed."
microsoft support says this:
CAUSE
The string for the target folder (the folder specified to store the database backup, or the one used for the transaction log backup or the one used for reports) in a maintenance plan contains "-S". For example, the directory path "C:\Db-Save" contains an "-S" string.
WORKAROUND
To work around this issue, do not use strings that contain "-S" for a directory path. Also note that the error only occurs when the "S" that follows the dash "-" is an uppercase letter ("S"
.
i changed the directory path to include no "s" at all but it still fails.
any ideas??
i'm setting up a db maintenance plan (running windows 2000). but when i run the jobs, it fails i get the following message in job history:
"sqlmaint.exe failed. [SQLSTATE 42000][Error 22029]. The step failed."
microsoft support says this:
CAUSE
The string for the target folder (the folder specified to store the database backup, or the one used for the transaction log backup or the one used for reports) in a maintenance plan contains "-S". For example, the directory path "C:\Db-Save" contains an "-S" string.
WORKAROUND
To work around this issue, do not use strings that contain "-S" for a directory path. Also note that the error only occurs when the "S" that follows the dash "-" is an uppercase letter ("S"
. i changed the directory path to include no "s" at all but it still fails.
any ideas??