June 13, 2008 at 2:54 am
Hi,
I have this problem: I setup a Maintenace Plain with check integrity, backup database every day and backup transaction log every day.
The check integrity and backup database have no problem, but backup transaction log end with this error:
Executed like user: sa. Cannot execute sqlmaint.exe. [SQLSTATE 42000] (error 22029).
Anyone can help me?
tks
max
June 13, 2008 at 4:22 am
Hi,
Have you checked that your database isn't in Simple recovery mode? You can't backup the log if it is.
Cath
June 13, 2008 at 8:18 am
If it is not in simple recovery mode, take a look at some of these. Seems like various issues will pop this message. Anything additional in the log or when you check the plan history for that particular step? Also, what version/service pack are you running?
http://support.microsoft.com/kb/326485
http://www.dbforums.com/t812439.html
http://sql-server-performance.com/Community/forums/t/4946.aspx
-- You can't be late until you show up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply