Hi all,
I created a database maintenance plan with backup + transsactionlog backup+optimizations. The first two jobs work fine but the Optimizations job is failing with error:
sqlmaint.exe failed. SQLSTATE 42000, Error: 22029. The step failed.
User is admin on local box and "sysadmin" in db server role. Any suggestions to resolve this?
Thanks
Vinnie...check out this link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;326485
Friday, March 23, 2012
Optimizations job failure - SQLServer2000
Labels:
backup,
backupoptimizations,
created,
database,
failure,
job,
jobs,
maintenance,
microsoft,
mysql,
optimizations,
oracle,
plan,
server,
sql,
sqlserver2000,
transsactionlog
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment