Sunday, February 12, 2012

Backing Up XAction Log with DB Maint Mgr

I noticed that someone else had a similar problem to
mine. I followed the advice (verified that my database is
the only one in the maintenance plan (does not include
master or msdb)). Yet my Transaction Log backup still
fails with the same message:
"The job failed. The Job was invoked by User U1ST074SORTS2
\rdenison. The last step to run was step 1 (Step 1)."
"sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The
step failed."
Any other ideas? I'm really interested in resolving this
because my Xaction log gets huge, especially on a
distributor server.
Roger.
>--Original Message--
>All right guys are really helping me out. I looked up
>the proble and it has come down to the following The
>maintenace Plan says that it cannot do transaction log
>backups on the master and the msdb databases.
>
>My question now is how can I exclude those 2 DB's from
>the Transaction log backup portion of the maintenance
>Plan?
>
>>--Original Message--
>>
>>
>>Hello Jim,
>>
>>First of all, thanks to Tibor for pointing you in the
>right direction.
>>Just as an additional information,
>>you can refer to the following article which explains
>how to t-shoot
>>General SQL Maint Wiz failures,
>>
>>INF: Troubleshooting Database Maintenance Plan Failures
>>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;288577
>>
>>In case, you are doing Transaction log backups of one of
>the databases
>>which is set to
>>Simple Recovery Mode, you might want to refer to
>following article
>>explaining this scenario,
>>
>>BUG: Expired Transaction Log Backups May Not Be Deleted
>by Maintenance Plan
>>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;303292
>>
>>Please let us know if these suggestions resolve your
>issue, if not , feel
>>free to post any further questions you have.
>>
>>Thanks for posting to MSDN Managed Newsgroup.
>>
>>Vikrant Dalwale
>>
>>Microsoft SQL Server Support Professional
>>
>>Microsoft highly recommends to all of our customers
>that they visit the
>>http://www.microsoft.com/protect site and perform the
>three straightforward
>>steps listed to improve your computer's security."
>>This posting is provided "AS IS" with no warranties, and
>confers no rights.
>>
>>
>>
>>--
>>Content-Class: urn:content-classes:message
>>From: "Jim" <jim.abel@.lmco.com>
>>Sender: "Jim" <jim.abel@.lmco.com>
>>
>>That helped. So now I have an error with the
>transaction
>>log backup portion of the Maintenace Plan.
>>
>>Here is the erro
>>
>>======================================================== >== >>Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe
>>failed. [SQLSTATE 42000] (Error 22029). The step
>failed.
>>===============================================Make sure your database is in Full Recovery mode and that it has been backed
up at least once.
Try the backup log command from Query Analyzer and see if that works...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:06e401c3d149$308a3e90$a501280a@.phx.gbl...
> I noticed that someone else had a similar problem to
> mine. I followed the advice (verified that my database is
> the only one in the maintenance plan (does not include
> master or msdb)). Yet my Transaction Log backup still
> fails with the same message:
> "The job failed. The Job was invoked by User U1ST074SORTS2
> \rdenison. The last step to run was step 1 (Step 1)."
> "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The
> step failed."
> Any other ideas? I'm really interested in resolving this
> because my Xaction log gets huge, especially on a
> distributor server.
> Roger.
> >--Original Message--
> >All right guys are really helping me out. I looked up
> >the proble and it has come down to the following The
> >maintenace Plan says that it cannot do transaction log
> >backups on the master and the msdb databases.
> >
> >My question now is how can I exclude those 2 DB's from
> >the Transaction log backup portion of the maintenance
> >Plan?
> >
> >>--Original Message--
> >>
> >>
> >>Hello Jim,
> >>
> >>First of all, thanks to Tibor for pointing you in the
> >right direction.
> >>Just as an additional information,
> >>you can refer to the following article which explains
> >how to t-shoot
> >>General SQL Maint Wiz failures,
> >>
> >>INF: Troubleshooting Database Maintenance Plan Failures
> >>http://support.microsoft.com/default.aspx?scid=kb;en-
> >us;288577
> >>
> >>In case, you are doing Transaction log backups of one of
> >the databases
> >>which is set to
> >>Simple Recovery Mode, you might want to refer to
> >following article
> >>explaining this scenario,
> >>
> >>BUG: Expired Transaction Log Backups May Not Be Deleted
> >by Maintenance Plan
> >>http://support.microsoft.com/default.aspx?scid=kb;en-
> >us;303292
> >>
> >>Please let us know if these suggestions resolve your
> >issue, if not , feel
> >>free to post any further questions you have.
> >>
> >>Thanks for posting to MSDN Managed Newsgroup.
> >>
> >>Vikrant Dalwale
> >>
> >>Microsoft SQL Server Support Professional
> >>
> >>Microsoft highly recommends to all of our customers
> >that they visit the
> >>http://www.microsoft.com/protect site and perform the
> >three straightforward
> >>steps listed to improve your computer's security."
> >>This posting is provided "AS IS" with no warranties, and
> >confers no rights.
> >>
> >>
> >>
> >>--
> >>Content-Class: urn:content-classes:message
> >>From: "Jim" <jim.abel@.lmco.com>
> >>Sender: "Jim" <jim.abel@.lmco.com>
> >>
> >>That helped. So now I have an error with the
> >transaction
> >>log backup portion of the Maintenace Plan.
> >>
> >>Here is the erro
> >>
> >>========================================================> >==> >>Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe
> >>failed. [SQLSTATE 42000] (Error 22029). The step
> >failed.
> >>===============================================>
>|||That did the trick. Thanks.
Roger.
>--Original Message--
>Make sure your database is in Full Recovery mode and that
it has been backed
>up at least once.
>Try the backup log command from Query Analyzer and see if
that works...
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Computer Education Services Corporation (CESC),
Charlotte, NC
>www.computeredservices.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>
>"Roger Denison" <anonymous@.discussions.microsoft.com>
wrote in message
>news:06e401c3d149$308a3e90$a501280a@.phx.gbl...
>> I noticed that someone else had a similar problem to
>> mine. I followed the advice (verified that my database
is
>> the only one in the maintenance plan (does not include
>> master or msdb)). Yet my Transaction Log backup still
>> fails with the same message:
>> "The job failed. The Job was invoked by User
U1ST074SORTS2
>> \rdenison. The last step to run was step 1 (Step 1)."
>> "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).
The
>> step failed."
>> Any other ideas? I'm really interested in resolving
this
>> because my Xaction log gets huge, especially on a
>> distributor server.
>> Roger.
>> >--Original Message--
>> >All right guys are really helping me out. I looked up
>> >the proble and it has come down to the following The
>> >maintenace Plan says that it cannot do transaction log
>> >backups on the master and the msdb databases.
>> >
>> >My question now is how can I exclude those 2 DB's from
>> >the Transaction log backup portion of the maintenance
>> >Plan?
>> >
>> >>--Original Message--
>> >>
>> >>
>> >>Hello Jim,
>> >>
>> >>First of all, thanks to Tibor for pointing you in the
>> >right direction.
>> >>Just as an additional information,
>> >>you can refer to the following article which explains
>> >how to t-shoot
>> >>General SQL Maint Wiz failures,
>> >>
>> >>INF: Troubleshooting Database Maintenance Plan
Failures
>> >>http://support.microsoft.com/default.aspx?scid=kb;en-
>> >us;288577
>> >>
>> >>In case, you are doing Transaction log backups of one
of
>> >the databases
>> >>which is set to
>> >>Simple Recovery Mode, you might want to refer to
>> >following article
>> >>explaining this scenario,
>> >>
>> >>BUG: Expired Transaction Log Backups May Not Be
Deleted
>> >by Maintenance Plan
>> >>http://support.microsoft.com/default.aspx?scid=kb;en-
>> >us;303292
>> >>
>> >>Please let us know if these suggestions resolve your
>> >issue, if not , feel
>> >>free to post any further questions you have.
>> >>
>> >>Thanks for posting to MSDN Managed Newsgroup.
>> >>
>> >>Vikrant Dalwale
>> >>
>> >>Microsoft SQL Server Support Professional
>> >>
>> >>Microsoft highly recommends to all of our customers
>> >that they visit the
>> >>http://www.microsoft.com/protect site and perform the
>> >three straightforward
>> >>steps listed to improve your computer's security."
>> >>This posting is provided "AS IS" with no warranties,
and
>> >confers no rights.
>> >>
>> >>
>> >>
>> >>--
>> >>Content-Class: urn:content-classes:message
>> >>From: "Jim" <jim.abel@.lmco.com>
>> >>Sender: "Jim" <jim.abel@.lmco.com>
>> >>
>> >>That helped. So now I have an error with the
>> >transaction
>> >>log backup portion of the Maintenace Plan.
>> >>
>> >>Here is the erro
>> >>
>>========================================================>> >==>> >>Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe
>> >>failed. [SQLSTATE 42000] (Error 22029). The step
>> >failed.
>> >>===============================================>>
>
>.
>

No comments:

Post a Comment