Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abogomolov
Starting Member
2 Posts |
 Posted - 2009-03-31 : 10:31:58
|
| Hi,When I create a new maintenance plan through the Wizard it shows up under SQL Server Agent - Jobs, but the plan itself is not showing up under Maintenance Plans. I'm unable to edit the plan and it fails when I try to execute it.Below is the error message that I get from the Job History PageMessageExecuted as user: DCSDAQAR\SYSTEM. ...on 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:25:32 AM Progress: 2009-03-31 10:25:32.75 Source: {9B3C421E-047D-438G-8C72-D101F5B236BD} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-03-31 10:25:33.24 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'I:\Backup\EZ3".: 50% complete End Progress Progress: 2009-03-31 10:25:33.24 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'I:\Backup\EZ3".: 100% complete End Progress Progress: 2009-03-31 10:25:33.99 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [EZ3_PRO_001] TO DISK = N'I:\Backup".: 100% complete End Progress Progress: 2009-03-31 10:25:34.42 Source: Back Up Database (Transaction... The package execution fa... The step failed.I've tried reinstalling SSIS but it did not help. I would greatly appreciate any help on this issue.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-31 : 11:45:33
|
| Is your service packs for SQL Server upto date? |
 |
|
|
abogomolov
Starting Member
2 Posts |
Posted - 2009-03-31 : 11:50:11
|
| SP3 |
|
|
|
|
|
|
SQL Server 2005 Maintenance Plan Not Showing Up