May 7, 2002 at 4:12 am
My job (created by a maintenance plan) for backing up databases is failing. Here is the code found in the only step in the job:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 133D8E07-56E9-11D6-8C46-0050DABB95A4 -VrfyBackup -BkUpMedia DISK -BkUpDB -UseDefDir -DelBkUps 24HOURS -BkExt "BAK"'
When I execute it in Query Analyzer I get the following error:
Output of sqlmaint.exe
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft (R) SQLMaint Utility (Unicode), Version 7.00.961
Copyright (C) Microsoft Corporation, 1995 - 1998
Logged on to SQL Server 'BDSQLDEV01' as 'IDC\auto-notification' (trusted)
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
This is always returned in less than 1 second as if its not even trying to do anything.
I'm sure many of you have seen similar errors. I'm wondering has anyone found out why this error occurs and how to fix it?
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
May 7, 2002 at 5:00 am
You'll forgive me for answering my own question, but I just found out how to fix this problem.
Enties in sysdbmaintplan_databases and sysdbmaintplans were missing. So I inserted one row into each table and now I can execute the command in Query Analyzer and the backups are being created as if the job were running.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply