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
Showing posts with label transsactionlog. Show all posts
Showing posts with label transsactionlog. Show all posts
Friday, March 23, 2012
Subscribe to:
Posts (Atom)