September 23, 2008 at 8:59 pm
Hi All,
having problems with xp_sqlmaint and was wondering if someone knew the answer or could provide a link where I can find what all the switches mean so i can try and work it out. The code I'm running is
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 831C8381-B424-4AB1-8124-135944F49E7B -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\DBA_ Hourly TLog Backup6.txt" -DelTxtRpt 4DAYS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs" -DelBkUps 26HOURS -CrBkSubDir -BkExt "TRN"'
And the error is
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039
Copyright (C) Microsoft Corporation, 1995 - 1998
NULL
Logged on to SQL Server 'WEBSERVER'
as 'sa2' (non-trusted)
NULL
Starting maintenance plan 'DBA: Hourly TLog Backup' on 9/24/2008 12:27:14 PM
NULL
[1] Database affiliate: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\affiliate\affiliate_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[2] Database affiliate: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[3] Database BusyatWork: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\BusyatWork\BusyatWork_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[4] Database BusyatWork: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[5] Database Events: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\Events\Events_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[6] Database Events: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[7] Database ExecutiveAlliance: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\ExecutiveAlliance\ExecutiveAlliance_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[8] Database ExecutiveAlliance: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[9] Database HedleyGroup: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\HedleyGroup\HedleyGroup_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[10] Database HedleyGroup: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[11] Database MyBodyBrilliant: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\MyBodyBrilliant\MyBodyBrilliant_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[12] Database MyBodyBrilliant: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
Backup can not be performed on database 'NewGoogle'. This sub task is ignored.
NULL
NULL
NULL
[13] Database PortfolioTracker: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\PortfolioTracker\PortfolioTracker_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[14] Database PortfolioTracker: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[15] Database PositiveRealEstate: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\PositiveRealEstate\PositiveRealEstate_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[16] Database PositiveRealEstate: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[17] Database PrimaryDevelopment: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\PrimaryDevelopment\PrimaryDevelopment_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[18] Database PrimaryDevelopment: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
Backup can not be performed on database 'PrimaryQualityControl'. This sub task is ignored.
NULL
NULL
NULL
[19] Database RealEstateInvestor: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\RealEstateInvestor\RealEstateInvestor_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[20] Database RealEstateInvestor: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[21] Database ReedConstruction: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\ReedConstruction\ReedConstruction_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[22] Database ReedConstruction: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[23] Database SampleSite: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\SampleSite\SampleSite_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[24] Database SampleSite: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[25] Database Source: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\Source\Source_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[26] Database Source: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
[27] Database SourcePropertyGroup: Transaction Log Backup...
NULL
Destination: [C:\Oxcyon Centralpoint\SQLBackups\SQLBackups_Logs\SourcePropertyGroup\SourcePropertyGroup_tlog_200809241227.TRN]
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[28] Database SourcePropertyGroup: Verifying Backup...
NULL
NULL
** Execution Time: 0 hrs, 0 mins, 1 secs **
NULL
NULL
[Microsoft SQL-DMO (ODBC SQLState: 42S02)] Error 208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'msdb.dbo.log_shipping_databases'.
NULL
Backup can not be performed on database 'SQLdmRepository'. This sub task is ignored.
NULL
NULL
NULL
Deleting old text reports...
0 file(s) deleted.
NULL
NULL
End of maintenance plan 'DBA: Hourly TLog Backup' on 9/24/2008 12:27:17 PM
NULL
SQLMAINT.EXE Process Exit Code: 1 (Failed)
NULL
September 25, 2008 at 6:27 am
Please make sure the maintenance plan or job does not have additional T-SQL script which is doing some thing with the table 'msdb.dbo.log_shipping_databases'.
or
Create a new maint plan with same functionality and test it if it is working then drop the old one which is giving the problem.
Rajesh Kasturi
October 12, 2011 at 2:45 am
This type of error 'NULL' comes when the service accounts is not added in windows acivie dictonary on Production server.
Because the agent could not able to contect at the production server.
Please add SQL SERVER Account and SQl SERVER Agent account in windows AD in admin group.
Thanks
Pradeep Madheshiya
Sr. DBA Vertex
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply