Hello, in SQL 2000
One of four log shipping processes (four databases) is giving me fits. Of course it is the most important database.
On the destination server I get the following log shipping copy job error:
[tt]Executed as user: Admin, sqlmaint.exe failed. [SQLSTATE 42000](Error 22029). The step failed.[/tt]
However, it is not all the time and the monitoring server says it is in sync.
I have rebuilt the database maintenance plan and still have the problem. All have the secondary load state set to "No Recovery Mode" instead of "Standby Mode", and I do not Terminate users in database.
- Is this error something to worry about?
- If so how do I fix it?
Thanks
djj
One of four log shipping processes (four databases) is giving me fits. Of course it is the most important database.
On the destination server I get the following log shipping copy job error:
[tt]Executed as user: Admin, sqlmaint.exe failed. [SQLSTATE 42000](Error 22029). The step failed.[/tt]
However, it is not all the time and the monitoring server says it is in sync.
I have rebuilt the database maintenance plan and still have the problem. All have the secondary load state set to "No Recovery Mode" instead of "Standby Mode", and I do not Terminate users in database.
- Is this error something to worry about?
- If so how do I fix it?
Thanks
djj