We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL 2000 TRANSACTION BACKUP ERROR

yostnet
yostnet asked
on
Medium Priority
398 Views
Last Modified: 2012-06-27
We started getting an error in part of our maintenance plan.  This has been running forever and within the last week, started erroring out.

Event Type:      Warning
Event Source:      SQLSERVERAGENT
Event Category:      Job Engine
Event ID:      208
Date:            4/19/2011
Time:            7:27:28 AM
User:            N/A
Computer:      SERVER01
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'Non AA database backup'' (0xFB47AEB8DD6DED4898606D6E954CAC8E) - Status: Failed - Invoked on: 2011-04-19 07:27:26 - Message: The job failed.  The Job was invoked by User MES\administrator.  The last step to run was step 1 (Step 1).


EXECUTE master.dbo.xp_sqlmaint N'-PlanID D1772498-25D5-45D6-9C9D-2317BBB65CC5 -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpLog "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP_TRN" -DelBkUps 4DAYS -BkExt "TRN"'
Comment
Watch Question

Database Analyst
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
hmm | guess it has not run in quite some time.

is there a way to reset the TRN maintenance plan?
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
goes to a local drive.

Nothing has changed |

disk space is about 3gb or so.

Commented:
How about the available space in MSDB and master
CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Top Expert 2012

Commented:
And another question:
Do you have a valid Full backup for the database?

Author

Commented:
thx all
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*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.