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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-02-19 : 14:26:51
|
| Team,My Maintenanceplan failed with below error,this was a cluster serverPRO\sqladmin. ...on 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:10:23 PM Error: 2010-02-19 14:10:38.26 Code: 0xC00291EC Source: {D9C17F9D-B647-474B-891D-F87F244CE2C3} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2010-02-19 14:10:38.27 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2010-02-19 14:10:52.39 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-02-19 : 16:27:40
|
| thanks tara,can you provide the script for the maintenance plans |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
cluster server