i keep getting the following error in my Event Viewer regarding a maintnance
plan I have set up in MS SQL Server 2000:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan master, msdb, model''
(0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
Any ideas about what I might be doing wrong?
--
John SchusterJohn Schuster wrote:
> i keep getting the following error in my Event Viewer regarding a maintnan
ce
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Pl
an
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
You can't do a transaction log backup on a database that is in Simple
recovery mode.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||> Any ideas about what I might be doing wrong?
Specify a report file for the maint plan. In there you will find the error m
essages that lead to the
job failure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>i keep getting the following error in my Event Viewer regarding a maintnanc
e
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Pl
an
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
> --
> John Schuster|||I set up a report and i get the following which doesn't tell me much:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:07 AM
Backup can not be performed on database 'master'. This sub task is ignored.
[1] Database model: Transaction Log Backup...
Destination: & #91;X:\MSSQL\EPDdocs_BACKUP\model_tlog_2
00611140000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:08 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
--
John Schuster
"Tibor Karaszi" wrote:
> Specify a report file for the maint plan. In there you will find the error
messages that lead to the
> job failure.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>
>|||Here's the problem:
> Backup can not be performed on database 'msdb'. This sub task is ignored.
You are trying to do a log backup on a database which is in simple recovery
mode. No can do.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...[vbcol=seagreen]
>I set up a report and i get the following which doesn't tell me much:
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
> Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
> 11/14/2006 12:00:07 AM
> Backup can not be performed on database 'master'. This sub task is ignored
.
> [1] Database model: Transaction Log Backup...
> Destination: & #91;X:\MSSQL\EPDdocs_BACKUP\model_tlog_2
00611140000.TRN]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [2] Database model: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> Backup can not be performed on database 'msdb'. This sub task is ignored.
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
> 11/14/2006 12:00:08 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> --
> John Schuster
>
> "Tibor Karaszi" wrote:
>|||Thank you for your help.
--
John Schuster
"Tibor Karaszi" wrote:
> Here's the problem:
>
> You are trying to do a log backup on a database which is in simple recover
y mode. No can do.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...
>sql
Showing posts with label scheduled. Show all posts
Showing posts with label scheduled. Show all posts
Friday, March 30, 2012
Maintenance plan failing
i keep getting the following error in my Event Viewer regarding a maintnance
plan I have set up in MS SQL Server 2000:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan master, msdb, model''
(0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
Any ideas about what I might be doing wrong?
John Schuster
John Schuster wrote:
> i keep getting the following error in my Event Viewer regarding a maintnance
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
You can't do a transaction log backup on a database that is in Simple
recovery mode.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||I set up a report and i get the following which doesn't tell me much:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:07 AM
Backup can not be performed on database 'master'. This sub task is ignored.
[1] Database model: Transaction Log Backup...
Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.T RN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:08 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
John Schuster
"Tibor Karaszi" wrote:
> Specify a report file for the maint plan. In there you will find the error messages that lead to the
> job failure.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>
>
|||Thank you for your help.
John Schuster
"Tibor Karaszi" wrote:
> Here's the problem:
>
> You are trying to do a log backup on a database which is in simple recovery mode. No can do.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...
>
plan I have set up in MS SQL Server 2000:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan master, msdb, model''
(0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
Any ideas about what I might be doing wrong?
John Schuster
John Schuster wrote:
> i keep getting the following error in my Event Viewer regarding a maintnance
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
You can't do a transaction log backup on a database that is in Simple
recovery mode.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||I set up a report and i get the following which doesn't tell me much:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:07 AM
Backup can not be performed on database 'master'. This sub task is ignored.
[1] Database model: Transaction Log Backup...
Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.T RN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:08 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
John Schuster
"Tibor Karaszi" wrote:
> Specify a report file for the maint plan. In there you will find the error messages that lead to the
> job failure.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>
>
|||Thank you for your help.
John Schuster
"Tibor Karaszi" wrote:
> Here's the problem:
>
> You are trying to do a log backup on a database which is in simple recovery mode. No can do.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...
>
Maintenance plan failing
i keep getting the following error in my Event Viewer regarding a maintnance
plan I have set up in MS SQL Server 2000:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan master, msdb, model''
(0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
Any ideas about what I might be doing wrong?
--
John SchusterJohn Schuster wrote:
> i keep getting the following error in my Event Viewer regarding a maintnance
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
You can't do a transaction log backup on a database that is in Simple
recovery mode.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||> Any ideas about what I might be doing wrong?
Specify a report file for the maint plan. In there you will find the error messages that lead to the
job failure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>i keep getting the following error in my Event Viewer regarding a maintnance
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
> --
> John Schuster|||I set up a report and i get the following which doesn't tell me much:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:07 AM
Backup can not be performed on database 'master'. This sub task is ignored.
[1] Database model: Transaction Log Backup...
Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:08 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
--
John Schuster
"Tibor Karaszi" wrote:
> > Any ideas about what I might be doing wrong?
> Specify a report file for the maint plan. In there you will find the error messages that lead to the
> job failure.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
> >i keep getting the following error in my Event Viewer regarding a maintnance
> > plan I have set up in MS SQL Server 2000:
> >
> > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> > 'DB Maintenance Plan master, msdb, model''
> > (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> > 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> > Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> >
> > Any ideas about what I might be doing wrong?
> > --
> > John Schuster
>
>|||Here's the problem:
> Backup can not be performed on database 'msdb'. This sub task is ignored.
You are trying to do a log backup on a database which is in simple recovery mode. No can do.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...
>I set up a report and i get the following which doesn't tell me much:
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
> Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
> 11/14/2006 12:00:07 AM
> Backup can not be performed on database 'master'. This sub task is ignored.
> [1] Database model: Transaction Log Backup...
> Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.TRN]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [2] Database model: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> Backup can not be performed on database 'msdb'. This sub task is ignored.
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
> 11/14/2006 12:00:08 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> --
> John Schuster
>
> "Tibor Karaszi" wrote:
>> > Any ideas about what I might be doing wrong?
>> Specify a report file for the maint plan. In there you will find the error messages that lead to
>> the
>> job failure.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
>> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>> >i keep getting the following error in my Event Viewer regarding a maintnance
>> > plan I have set up in MS SQL Server 2000:
>> >
>> > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
>> > 'DB Maintenance Plan master, msdb, model''
>> > (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
>> > 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
>> > Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
>> >
>> > Any ideas about what I might be doing wrong?
>> > --
>> > John Schuster
>>|||Thank you for your help.
--
John Schuster
"Tibor Karaszi" wrote:
> Here's the problem:
> > Backup can not be performed on database 'msdb'. This sub task is ignored.
> You are trying to do a log backup on a database which is in simple recovery mode. No can do.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...
> >I set up a report and i get the following which doesn't tell me much:
> >
> > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> > 'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
> > Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
> > 11/14/2006 12:00:07 AM
> > Backup can not be performed on database 'master'. This sub task is ignored.
> >
> > [1] Database model: Transaction Log Backup...
> > Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.TRN]
> >
> > ** Execution Time: 0 hrs, 0 mins, 1 secs **
> >
> > [2] Database model: Verifying Backup...
> >
> > ** Execution Time: 0 hrs, 0 mins, 1 secs **
> >
> > Backup can not be performed on database 'msdb'. This sub task is ignored.
> >
> > Deleting old text reports... 0 file(s) deleted.
> >
> > End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
> > 11/14/2006 12:00:08 AM
> > SQLMAINT.EXE Process Exit Code: 1 (Failed)
> > --
> > John Schuster
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> > Any ideas about what I might be doing wrong?
> >>
> >> Specify a report file for the maint plan. In there you will find the error messages that lead to
> >> the
> >> job failure.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> >> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
> >> >i keep getting the following error in my Event Viewer regarding a maintnance
> >> > plan I have set up in MS SQL Server 2000:
> >> >
> >> > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> >> > 'DB Maintenance Plan master, msdb, model''
> >> > (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> >> > 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> >> > Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> >> >
> >> > Any ideas about what I might be doing wrong?
> >> > --
> >> > John Schuster
> >>
> >>
> >>
>
plan I have set up in MS SQL Server 2000:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan master, msdb, model''
(0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
Any ideas about what I might be doing wrong?
--
John SchusterJohn Schuster wrote:
> i keep getting the following error in my Event Viewer regarding a maintnance
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
You can't do a transaction log backup on a database that is in Simple
recovery mode.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||> Any ideas about what I might be doing wrong?
Specify a report file for the maint plan. In there you will find the error messages that lead to the
job failure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>i keep getting the following error in my Event Viewer regarding a maintnance
> plan I have set up in MS SQL Server 2000:
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan master, msdb, model''
> (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> Any ideas about what I might be doing wrong?
> --
> John Schuster|||I set up a report and i get the following which doesn't tell me much:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:07 AM
Backup can not be performed on database 'master'. This sub task is ignored.
[1] Database model: Transaction Log Backup...
Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database model: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'msdb'. This sub task is ignored.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
11/14/2006 12:00:08 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
--
John Schuster
"Tibor Karaszi" wrote:
> > Any ideas about what I might be doing wrong?
> Specify a report file for the maint plan. In there you will find the error messages that lead to the
> job failure.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
> >i keep getting the following error in my Event Viewer regarding a maintnance
> > plan I have set up in MS SQL Server 2000:
> >
> > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> > 'DB Maintenance Plan master, msdb, model''
> > (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> > 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> > Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> >
> > Any ideas about what I might be doing wrong?
> > --
> > John Schuster
>
>|||Here's the problem:
> Backup can not be performed on database 'msdb'. This sub task is ignored.
You are trying to do a log backup on a database which is in simple recovery mode. No can do.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...
>I set up a report and i get the following which doesn't tell me much:
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
> Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
> 11/14/2006 12:00:07 AM
> Backup can not be performed on database 'master'. This sub task is ignored.
> [1] Database model: Transaction Log Backup...
> Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.TRN]
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [2] Database model: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> Backup can not be performed on database 'msdb'. This sub task is ignored.
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
> 11/14/2006 12:00:08 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> --
> John Schuster
>
> "Tibor Karaszi" wrote:
>> > Any ideas about what I might be doing wrong?
>> Specify a report file for the maint plan. In there you will find the error messages that lead to
>> the
>> job failure.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
>> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
>> >i keep getting the following error in my Event Viewer regarding a maintnance
>> > plan I have set up in MS SQL Server 2000:
>> >
>> > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
>> > 'DB Maintenance Plan master, msdb, model''
>> > (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
>> > 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
>> > Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
>> >
>> > Any ideas about what I might be doing wrong?
>> > --
>> > John Schuster
>>|||Thank you for your help.
--
John Schuster
"Tibor Karaszi" wrote:
> Here's the problem:
> > Backup can not be performed on database 'msdb'. This sub task is ignored.
> You are trying to do a log backup on a database which is in simple recovery mode. No can do.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> news:AC9FF4A5-0CF5-4661-A9F1-577320DB70A3@.microsoft.com...
> >I set up a report and i get the following which doesn't tell me much:
> >
> > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> > 'EPDDOCS3' as 'SEP\EPDDOCS3$' (trusted)
> > Starting maintenance plan 'DB Maintenance Plan master, msdb, model' on
> > 11/14/2006 12:00:07 AM
> > Backup can not be performed on database 'master'. This sub task is ignored.
> >
> > [1] Database model: Transaction Log Backup...
> > Destination: [X:\MSSQL\EPDdocs_BACKUP\model_tlog_200611140000.TRN]
> >
> > ** Execution Time: 0 hrs, 0 mins, 1 secs **
> >
> > [2] Database model: Verifying Backup...
> >
> > ** Execution Time: 0 hrs, 0 mins, 1 secs **
> >
> > Backup can not be performed on database 'msdb'. This sub task is ignored.
> >
> > Deleting old text reports... 0 file(s) deleted.
> >
> > End of maintenance plan 'DB Maintenance Plan master, msdb, model' on
> > 11/14/2006 12:00:08 AM
> > SQLMAINT.EXE Process Exit Code: 1 (Failed)
> > --
> > John Schuster
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> > Any ideas about what I might be doing wrong?
> >>
> >> Specify a report file for the maint plan. In there you will find the error messages that lead to
> >> the
> >> job failure.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "John Schuster" <JohnSchuster@.discussions.microsoft.com> wrote in message
> >> news:D4C6E493-E90D-45E6-80B2-3BC0170D8DEB@.microsoft.com...
> >> >i keep getting the following error in my Event Viewer regarding a maintnance
> >> > plan I have set up in MS SQL Server 2000:
> >> >
> >> > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> >> > 'DB Maintenance Plan master, msdb, model''
> >> > (0x0D97085E32705247B590ADA245D3FE07) - Status: Failed - Invoked on:
> >> > 2006-11-14 00:00:05 - Message: The job failed. The Job was invoked by
> >> > Schedule 76 (Schedule 1). The last step to run was step 1 (Step 1).
> >> >
> >> > Any ideas about what I might be doing wrong?
> >> > --
> >> > John Schuster
> >>
> >>
> >>
>
Wednesday, March 28, 2012
Maintenance plan backups fail
Hi, I have a scheduled maintenance plan that backs up my database (SQL 2000). The db is 108 Meg. Usually the backup files are around 89 Meg and the transaction log backups are around 4.5 Megs.
The problem is that every once a while the backup fails with the following error:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\CRM_db_200312230100.BAK' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
What usually happens is that the last backup that has failed has a size of 9 or 8 Gigs!
My guess is that a backup file gets corrupt (the size increases to 8 Gigs) and the server runs out of space and wont be able to do more backups. However I cant figure out why the backup file size increases to and gets corrupt.
Can anyone help me?What does the error log say...
did you a dbcc checkdb?|||Thanks for your reply, the error log says:
1.Source:Backup
BACKUP failed to complete the command BACKUP DATABASE [MYDB] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MYDB_db_200312230100.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
2.Source:spid54
BackupMedium::ReportIoError: write failure on backup device 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MYDB_db_200312230100.BAK'. Operating system error 112(There is not enough space on the disk.).
3.Source:spid54
Internal I/O request 0x12844D98: Op: Write, pBuffer: 0x12C40000, Size: 983040, Position: 14752256, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xE11A00, OffsetHigh: 0x0, m_buf: 0x12C40000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile: C:\Program Files\Microsoft SQL
It looks like somthing happended to the last backup and the size increased to 8 Gigs and the disk ran out of space, but I can't figure why this happenes every once in a while.
Thanks
Originally posted by Brett Kaiser
What does the error log say...
did you a dbcc checkdb?|||You can't just assume that the backup gets corrupted without trying to restore it. Have you tried to do that?|||I havn't but there must be somthing wrong with it, since its 8 gig instead of 80 Megs, plus when I deleted it and made a backup manualy the size of the new backup was the regular 80 megs
Originally posted by rdjabarov
You can't just assume that the backup gets corrupted without trying to restore it. Have you tried to do that?
The problem is that every once a while the backup fails with the following error:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\CRM_db_200312230100.BAK' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
What usually happens is that the last backup that has failed has a size of 9 or 8 Gigs!
My guess is that a backup file gets corrupt (the size increases to 8 Gigs) and the server runs out of space and wont be able to do more backups. However I cant figure out why the backup file size increases to and gets corrupt.
Can anyone help me?What does the error log say...
did you a dbcc checkdb?|||Thanks for your reply, the error log says:
1.Source:Backup
BACKUP failed to complete the command BACKUP DATABASE [MYDB] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MYDB_db_200312230100.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
2.Source:spid54
BackupMedium::ReportIoError: write failure on backup device 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MYDB_db_200312230100.BAK'. Operating system error 112(There is not enough space on the disk.).
3.Source:spid54
Internal I/O request 0x12844D98: Op: Write, pBuffer: 0x12C40000, Size: 983040, Position: 14752256, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xE11A00, OffsetHigh: 0x0, m_buf: 0x12C40000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile: C:\Program Files\Microsoft SQL
It looks like somthing happended to the last backup and the size increased to 8 Gigs and the disk ran out of space, but I can't figure why this happenes every once in a while.
Thanks
Originally posted by Brett Kaiser
What does the error log say...
did you a dbcc checkdb?|||You can't just assume that the backup gets corrupted without trying to restore it. Have you tried to do that?|||I havn't but there must be somthing wrong with it, since its 8 gig instead of 80 Megs, plus when I deleted it and made a backup manualy the size of the new backup was the regular 80 megs
Originally posted by rdjabarov
You can't just assume that the backup gets corrupted without trying to restore it. Have you tried to do that?
Monday, March 12, 2012
Maint Plans
Hi
SQL Server 2005 sp2
I have a maint plan that was created via the wizzard using separate schedule
fpr each task
sub_plan1 - history clean up; scheduled onec a day at 03:00AM
sub_plan2 - Full backup for all databases; scheduled onec a day at 03:00AM
sub_plan3 - Log backup for specific databases ; scheduled daily every 10
minutes
sub_plan4 - maintenace cleanup; scheduled onec a day at 03:00AM
I face 2 problems:
1. sub_plan2(Full) works only for those databases that are not part of
sub_plan3(Log)
2. sub_plan4 does not work
I will appreciate any help.
Thanks,
Yaniv
Hi
Have you set up the reporting and logging options for the maintenance plan
(next to manage connections) on tool bar. Knowing what the error messages
are! Make sure that your log backups are not running at the same time as the
full backup.
John
"Yan" <yaniv.etrogi@.gmail.com> wrote in message
news:%23yeqwseVIHA.5596@.TK2MSFTNGP05.phx.gbl...
> Hi
> SQL Server 2005 sp2
> I have a maint plan that was created via the wizzard using separate
> schedule fpr each task
> sub_plan1 - history clean up; scheduled onec a day at 03:00AM
> sub_plan2 - Full backup for all databases; scheduled onec a day at 03:00AM
> sub_plan3 - Log backup for specific databases ; scheduled daily every 10
> minutes
> sub_plan4 - maintenace cleanup; scheduled onec a day at 03:00AM
> I face 2 problems:
> 1. sub_plan2(Full) works only for those databases that are not part of
> sub_plan3(Log)
> 2. sub_plan4 does not work
>
> I will appreciate any help.
> Thanks,
> Yaniv
>
SQL Server 2005 sp2
I have a maint plan that was created via the wizzard using separate schedule
fpr each task
sub_plan1 - history clean up; scheduled onec a day at 03:00AM
sub_plan2 - Full backup for all databases; scheduled onec a day at 03:00AM
sub_plan3 - Log backup for specific databases ; scheduled daily every 10
minutes
sub_plan4 - maintenace cleanup; scheduled onec a day at 03:00AM
I face 2 problems:
1. sub_plan2(Full) works only for those databases that are not part of
sub_plan3(Log)
2. sub_plan4 does not work
I will appreciate any help.
Thanks,
Yaniv
Hi
Have you set up the reporting and logging options for the maintenance plan
(next to manage connections) on tool bar. Knowing what the error messages
are! Make sure that your log backups are not running at the same time as the
full backup.
John
"Yan" <yaniv.etrogi@.gmail.com> wrote in message
news:%23yeqwseVIHA.5596@.TK2MSFTNGP05.phx.gbl...
> Hi
> SQL Server 2005 sp2
> I have a maint plan that was created via the wizzard using separate
> schedule fpr each task
> sub_plan1 - history clean up; scheduled onec a day at 03:00AM
> sub_plan2 - Full backup for all databases; scheduled onec a day at 03:00AM
> sub_plan3 - Log backup for specific databases ; scheduled daily every 10
> minutes
> sub_plan4 - maintenace cleanup; scheduled onec a day at 03:00AM
> I face 2 problems:
> 1. sub_plan2(Full) works only for those databases that are not part of
> sub_plan3(Log)
> 2. sub_plan4 does not work
>
> I will appreciate any help.
> Thanks,
> Yaniv
>
Wednesday, March 7, 2012
Mail notifications for scheduled jobs
I have a sql server 2000 sp3a box with 4 named instances.
I have read all of the articles and I cannot get the 'send mail' stuff working.
I have a mailbox associated with the Domanin account that starts the sql server and sql server agent services. I installed Outlook and created a mail profile for this account. I bounced the SQL server agent on one of the Instances but when I go into the properties for the Agent, on the General Tab, the option to choose a mail profile is GREYED out. I tried 'xp_startmail' and I get this error: xp_startmail: failed with mail error 0x80040111
can anyone help???Are you logging on to the server as the account SQL runs under? You will need to be logged onto to the server with the service account in order to set the mail properties in the agent|||are you sure you have covered all of the basics. does the sql and sql agent services run under a network account that maps to the exchange account you are attempting to use?
have you attempted to use the outlook client installed on the db server.|||You've got about 9 months until maintstream support for SQL 2000 ends. Upgrade to SQL 2005 and use the Database Mail feature (a lightweight SMTP client, instead of the clunky MAPI compliant interface).
In case that is not an option, here are some MS KB articles on SQL 2000 and setting up mail profiles.
http://support.microsoft.com/kb/315886
http://support.microsoft.com/default.aspx/kb/281293
http://support.microsoft.com/kb/263556/EN-US/
Some CRITICAL things to remember:
1. Outlook is single-threaded; if it pops an error message at the console, it can and will lock up SQL's job system.
2. SQL Mail and SQL Agent mail do not have to use the same profile. However, you must set up each profile separately (ie, to use alerts you must set up SQL Agent Mail, to use xp_sendmail you must set up SQL Mail). The two features are set up in different places (SQL Agent mail is set up by right-clicking on SQL Agent and selecting properties; SQL Mail is set up under support services).
3. You will have to configure SQL Mail/SQL Agent Mail separately for each instance. You might want to consider a separate profile for each. Be careful of the overhead associated with running four MAPI client instances (plus for SQL instances) on the same server.
Having said all that, I don't really recommed using SQL Agent Mail or SQL mail on a production server. Like I said, upgrade to SQL 2005.
Regards,
hmscott
I have read all of the articles and I cannot get the 'send mail' stuff working.
I have a mailbox associated with the Domanin account that starts the sql server and sql server agent services. I installed Outlook and created a mail profile for this account. I bounced the SQL server agent on one of the Instances but when I go into the properties for the Agent, on the General Tab, the option to choose a mail profile is GREYED out. I tried 'xp_startmail' and I get this error: xp_startmail: failed with mail error 0x80040111
can anyone help???Are you logging on to the server as the account SQL runs under? You will need to be logged onto to the server with the service account in order to set the mail properties in the agent|||are you sure you have covered all of the basics. does the sql and sql agent services run under a network account that maps to the exchange account you are attempting to use?
have you attempted to use the outlook client installed on the db server.|||You've got about 9 months until maintstream support for SQL 2000 ends. Upgrade to SQL 2005 and use the Database Mail feature (a lightweight SMTP client, instead of the clunky MAPI compliant interface).
In case that is not an option, here are some MS KB articles on SQL 2000 and setting up mail profiles.
http://support.microsoft.com/kb/315886
http://support.microsoft.com/default.aspx/kb/281293
http://support.microsoft.com/kb/263556/EN-US/
Some CRITICAL things to remember:
1. Outlook is single-threaded; if it pops an error message at the console, it can and will lock up SQL's job system.
2. SQL Mail and SQL Agent mail do not have to use the same profile. However, you must set up each profile separately (ie, to use alerts you must set up SQL Agent Mail, to use xp_sendmail you must set up SQL Mail). The two features are set up in different places (SQL Agent mail is set up by right-clicking on SQL Agent and selecting properties; SQL Mail is set up under support services).
3. You will have to configure SQL Mail/SQL Agent Mail separately for each instance. You might want to consider a separate profile for each. Be careful of the overhead associated with running four MAPI client instances (plus for SQL instances) on the same server.
Having said all that, I don't really recommed using SQL Agent Mail or SQL mail on a production server. Like I said, upgrade to SQL 2005.
Regards,
hmscott
Subscribe to:
Posts (Atom)