We help IT Professionals succeed at work.

SQL Server 2000 Transaction log failing, SQLMAINT.exe process exit code: 1 failed

Rpowell460
Rpowell460 asked
on
Medium Priority
389 Views
Last Modified: 2012-08-13
I am using the DBMaintenance plan to backup the transaction log of two Databases. One database in the plan backs up the trans log just fine. But the other  Database trans log fails with the following error message:" SQLMAINT.exe process exit code: 1 failed"

When I try to backup the trans log of the failing Database manually and I notice in the wizard, my option for the Transaction log is greyed out. Not allowing me to select "Transaction log backup"??

Any words of wisdom??
Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
Hi 5thcav,

can you check whether the recovery model of that perticular database is 'Simple'. You can't backup the log files of a 'Simple' database

Cheers!
CERTIFIED EXPERT
Top Expert 2012
Commented:
That is because the Recovery model for that database is set at Simple not Full.   That is why you cannot backup the Transaction Log

If I can predict you next question:  Look up "Using Recovery Models" in Books Online :)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
Hi 5thcav,
I think you didn't read my point...
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.