Maintenance plan
in [Server Configuration]
|
From: Shay on 22 May 2010 08:53 Hi After the maintenance run at the end when it has to delete old backup files, therer is an error. error 208. Any idea? SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2 and all the patches. Than'x Shay
From: John Bell on 22 May 2010 16:44 On Sat, 22 May 2010 15:53:45 +0300, "Shay" <shayhanya(a)yahoo.com> wrote: >Hi > >After the maintenance run at the end when it has to delete old backup files, >therer is an error. error 208. > >Any idea? > > >SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2 and all >the patches. > >Than'x >Shay > Hi What is logged in the job history, SQL Server or Windows logs? Error 208 doesn't say much other than the is a problem! John
From: Shay on 22 May 2010 22:50 This 2 errors Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 22/05/2010 Time: 11:21:07 User: N/A Computer: PANDB Description: SQL Server Scheduled Job 'MaintenancePlan.Subplan_1' (0x53D62013D401044FBD28485D7DBDD64F) - Status: Failed - Invoked on: 2010-05-22 10:12:01 - Message: The job failed. The Job was invoked by User PANDOR\Administrator. The last step to run was step 1 (Subplan_1). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Event Type: Error Event Source: SQLISPackage Event Category: None Event ID: 12291 Date: 22/05/2010 Time: 11:21:05 User: PANDOR\Administrator Computer: PANDB Description: Package "MaintenancePlan" failed. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message news:k6ggv5l05eoce0e2fufp5990fnpt3n4rg4(a)4ax.com... > On Sat, 22 May 2010 15:53:45 +0300, "Shay" <shayhanya(a)yahoo.com> > wrote: > >>Hi >> >>After the maintenance run at the end when it has to delete old backup >>files, >>therer is an error. error 208. >> >>Any idea? >> >> >>SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2 and >>all >>the patches. >> >>Than'x >>Shay >> > > Hi > > What is logged in the job history, SQL Server or Windows logs? Error > 208 doesn't say much other than the is a problem! > > John > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5138 (20100522) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > >
From: Jeffrey Williams on 22 May 2010 23:24 View the history of the maintenance plan - not the history of the job. You will find the actual error in that history for the task that failed. "Shay" <shayhanya(a)yahoo.com> wrote in message news:#Dlc#Li#KHA.348(a)TK2MSFTNGP06.phx.gbl... > > This 2 errors > > Event Type: Warning > Event Source: SQLSERVERAGENT > Event Category: Job Engine > Event ID: 208 > Date: 22/05/2010 > Time: 11:21:07 > User: N/A > Computer: PANDB > Description: > SQL Server Scheduled Job 'MaintenancePlan.Subplan_1' > (0x53D62013D401044FBD28485D7DBDD64F) - Status: Failed - Invoked on: > 2010-05-22 10:12:01 - Message: The job failed. The Job was invoked by > User PANDOR\Administrator. The last step to run was step 1 (Subplan_1). > > For more information, see Help and Support Center at > http://go.microsoft.com/fwlink/events.asp. > > > > Event Type: Error > Event Source: SQLISPackage > Event Category: None > Event ID: 12291 > Date: 22/05/2010 > Time: 11:21:05 > User: PANDOR\Administrator > Computer: PANDB > Description: > Package "MaintenancePlan" failed. > > For more information, see Help and Support Center at > http://go.microsoft.com/fwlink/events.asp. > > > > > > > > > > > > > > > > > > > > > "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message > news:k6ggv5l05eoce0e2fufp5990fnpt3n4rg4(a)4ax.com... >> On Sat, 22 May 2010 15:53:45 +0300, "Shay" <shayhanya(a)yahoo.com> >> wrote: >> >>>Hi >>> >>>After the maintenance run at the end when it has to delete old backup >>>files, >>>therer is an error. error 208. >>> >>>Any idea? >>> >>> >>>SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2 and >>>all >>>the patches. >>> >>>Than'x >>>Shay >>> >> >> Hi >> >> What is logged in the job history, SQL Server or Windows logs? Error >> 208 doesn't say much other than the is a problem! >> >> John >> >> __________ Information from ESET NOD32 Antivirus, version of virus >> signature database 5138 (20100522) __________ >> >> The message was checked by ESET NOD32 Antivirus. >> >> http://www.eset.com >> >> >> > >
From: Shay on 22 May 2010 23:40 Maintenance Cleanup on Local server connection Cleanup Database Backup files Age: Older than 3 Days -1073548784 Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2010-05-20T00:57:22' " failed with the following error: "Error executing extended stored procedure: Invalid Parameter". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Date,Source,Severity,Plan Name,SubPlan Name,Task Name,Duration 05/23/2010 00:57:23,,Error,MaintenancePlan,Subplan_1,,01:57:20 05/23/2010 00:57:22,,Error,,,Maintenance Cleanup Task (pandb),00:00:01 05/22/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:30:15 05/22/2010 23:00:05,,Unknown,,,Check Database Integrity (pandb),00:27:01 05/22/2010 11:21:05,,Error,MaintenancePlan,Subplan_1,,01:09:00 05/22/2010 11:21:05,,Error,,,Maintenance Cleanup Task (pandb),00:00:00 05/22/2010 10:38:36,,Unknown,,,Back Up Database (Full) (pandb),00:42:29 05/22/2010 10:12:06,,Unknown,,,Check Database Integrity (pandb),00:26:29 05/22/2010 01:17:47,,Error,MaintenancePlan,Subplan_1,,02:17:40 05/22/2010 01:17:47,,Error,,,Maintenance Cleanup Task (pandb),00:00:00 05/21/2010 23:27:27,,Unknown,,,Back Up Database (Full) (pandb),01:50:20 05/21/2010 23:00:10,,Unknown,,,Check Database Integrity (pandb),00:27:16 05/21/2010 01:28:16,,Error,MaintenancePlan,Subplan_1,,02:28:12 05/21/2010 01:28:15,,Error,,,Maintenance Cleanup Task (pandb),00:00:01 05/20/2010 23:27:00,,Unknown,,,Back Up Database (Full) (pandb),02:01:15 05/20/2010 23:00:06,,Unknown,,,Check Database Integrity (pandb),00:26:53 05/20/2010 01:13:52,,Error,MaintenancePlan,Subplan_1,,02:13:48 05/20/2010 01:13:52,,Error,,,Maintenance Cleanup Task (pandb),00:00:00 05/19/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:46:45 05/19/2010 23:00:07,,Unknown,,,Check Database Integrity (pandb),00:26:59 05/19/2010 00:20:44,,Error,MaintenancePlan,Subplan_1,,01:20:41 05/19/2010 00:20:44,,Error,,,Maintenance Cleanup Task (pandb),00:00:00 05/18/2010 23:25:47,,Unknown,,,Back Up Database (Full) (pandb),00:54:56 05/18/2010 23:00:04,,Unknown,,,Check Database Integrity (pandb),00:25:42 "Jeffrey Williams" <jeff.williams3188(a)verizon.net> wrote in message news:uD0W3ii%23KHA.5476(a)TK2MSFTNGP06.phx.gbl... > View the history of the maintenance plan - not the history of the job. > You will find the actual error in that history for the task that failed. > > "Shay" <shayhanya(a)yahoo.com> wrote in message > news:#Dlc#Li#KHA.348(a)TK2MSFTNGP06.phx.gbl... >> >> This 2 errors >> >> Event Type: Warning >> Event Source: SQLSERVERAGENT >> Event Category: Job Engine >> Event ID: 208 >> Date: 22/05/2010 >> Time: 11:21:07 >> User: N/A >> Computer: PANDB >> Description: >> SQL Server Scheduled Job 'MaintenancePlan.Subplan_1' >> (0x53D62013D401044FBD28485D7DBDD64F) - Status: Failed - Invoked on: >> 2010-05-22 10:12:01 - Message: The job failed. The Job was invoked by >> User PANDOR\Administrator. The last step to run was step 1 (Subplan_1). >> >> For more information, see Help and Support Center at >> http://go.microsoft.com/fwlink/events.asp. >> >> >> >> Event Type: Error >> Event Source: SQLISPackage >> Event Category: None >> Event ID: 12291 >> Date: 22/05/2010 >> Time: 11:21:05 >> User: PANDOR\Administrator >> Computer: PANDB >> Description: >> Package "MaintenancePlan" failed. >> >> For more information, see Help and Support Center at >> http://go.microsoft.com/fwlink/events.asp. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message >> news:k6ggv5l05eoce0e2fufp5990fnpt3n4rg4(a)4ax.com... >>> On Sat, 22 May 2010 15:53:45 +0300, "Shay" <shayhanya(a)yahoo.com> >>> wrote: >>> >>>>Hi >>>> >>>>After the maintenance run at the end when it has to delete old backup >>>>files, >>>>therer is an error. error 208. >>>> >>>>Any idea? >>>> >>>> >>>>SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2 and >>>>all >>>>the patches. >>>> >>>>Than'x >>>>Shay >>>> >>> >>> Hi >>> >>> What is logged in the job history, SQL Server or Windows logs? Error >>> 208 doesn't say much other than the is a problem! >>> >>> John >>> >>> __________ Information from ESET NOD32 Antivirus, version of virus >>> signature database 5138 (20100522) __________ >>> >>> The message was checked by ESET NOD32 Antivirus. >>> >>> http://www.eset.com >>> >>> >>> >> >> > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5138 (20100522) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > >
|
Next
|
Last
Pages: 1 2 Prev: sysmail_mailitems Next: How do I determine default instance vs. named instance install? |