[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

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

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??
0
Rpowell460
Asked:
Rpowell460
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
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!
0
 
Anthony PerkinsCommented:
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 :)
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hi 5thcav,
I think you didn't read my point...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now