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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2010-03-23 : 19:06:35
|
| Patrons,Couple of days back while doing the Reboot of server the server on Fail-over has died out and shifted everything where the Quorum resides and it becomes ONE PHYSICAL BOX.Nevertheless, Databases were available for end-users and transactions being performed, but the Maintenance Plans were failed till the server got on its own Logical Box.Database Backups; Transaction Log Backup for every 15 minutes Duration have failed and the Error has depicted from the log viewer as following:Date 2/08/2010 7:51:36 AMLog Job History (Database Backups.Every night)Step ID 1Server SQLDISK02\SQL02Job Name Database Backups.Every nightStep Name Every nightDuration 00:00:49Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: Prime0\SQLProdAdmin. ...9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:51:36 AM Error: 2010-03-19 07:51:53.59 Code: 0xC00291EC Source: {190C192B-CE4A-4797-B50D-2A034013C004} 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-03-19 07:51:53.59 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-03-19 07:52:09.15 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed.My initial understanding was Everything became PHYSICAL BOX and LOGICAL BOX was Absent. so Maintenance Jobs cannot function and the error says it all.However, adding to my thinking and understanding can anyone give much better explanation.Thanks all. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2010-03-23 : 20:08:59
|
| Thanks Tara. Backup Log also failed. and also some other Maintenance jobs were also failed. In general, All the Maintenance jobs failed. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2010-03-23 : 22:50:01
|
| Yeah. I procured backups through running the script, may be backup log would also have worked but I haven't tried since Full backup did worked everytime during this unknown ordeal.Thanks. |
|
|
|
|
|
|
Server Failover Shifted