 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / November 2007Error 12291 in Event Log
We have a maintainance plan for full/diff/log backups of selected databases running at regular intervals through SQLAgent. The backups are working; I can restore the databases. But starting a few weeks ago we've been getting error messages in the system event log. First, there's an entry confirming the successful completion of the backups with ID 18265 (source MSSQL$...) Then comes the error: ID 12291 "Error in package ..." (source SQLISPackage) followed by a warning with ID 208 "SQL Server Scheduled Job ... - Status: Error ..." (source SQLAgent$...) As I said, the backups themselves seem to be successful, and the SQL Server "ERRORLOG" text file also contains no error messages in connection with the plans. This is still worrying us a bit, because we fear there might be a good reason for these error messages, and obviously we want to be quite certain that our backups are working properly and will be available if and when we need them. Does anyone have any insight/advice on Error 12291? Thanks Tom Juergens Hi Tom, Since some maintenance plans are very easy to create, have you tried creating a new or very similar maintenance plan and see if you still have the same problem? Or maybe deleting the existing maintenance plan and creating it again? Also, since the maintenance plan is an SSIS package, have you tried running the package manually from SSIS (like using the Execute Package Utility) and check for errors or warnings? Have you tried Logging on this SSIS package? Ben Nevarez Senior Database Administrator AIG SunAmerica > We have a maintainance plan for full/diff/log backups of selected databases > running at regular intervals through SQLAgent. The backups are working; I can [quoted text clipped - 20 lines] > Thanks > Tom Juergens Thanks to you both for the pointers and good ideas. I'll try your suggestions and post again here if I don't find a solution. Tom > Hi Tom, > [quoted text clipped - 35 lines] > > Thanks > > Tom Juergens You would need to post the whole log to get a full analysis. The plan should be generating a log file, not the error log, which may help. If not, configure it to generate a detailed log. Also check the package has no reference to mapped drives as the mappings may not be available to SQL Agent. Nigel Ainscoe > We have a maintainance plan for full/diff/log backups of selected > databases [quoted text clipped - 27 lines] > Thanks > Tom Juergens Hi Tom, To let us better understand your issue, could you please let us know the following questions: 1. What is the version of your SQL Server? (Run SELECT @@VERSION.) 2. Did the maintainance plan only backup your databases? 3. Could you please post all the event error messages here for more effective research? You may also mail me (changliw_at_microsoft_dot_com) the event error logs. Best regards, Charles Wang Microsoft Online Community Support ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ====================================================== My client has decided to reinstall the server, which is a good option since there are some other things that aren't quite right as well... So we just have to live with this behavior for another couple of weeks and I won't be investing much more time in finding a solution. Consider this case closed. Thanks Tom > Hi Tom, > To let us better understand your issue, could you please let us know the [quoted text clipped - 16 lines] > This posting is provided "AS IS" with no warranties, and confers no rights. > ====================================================== |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.