Re: Question about sql job, SQL 7 versus upgrade to SQL 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Goober at christianDOTnet (me_at_privacy.net)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 12:03:13 -0400

Here's the output from the job, once I turned on the Reporting for it:

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SISDB2' as 'MYDOMAIN\mylogin' (trusted)
Starting maintenance plan 'sfa backup - tape' on 7/8/2004 12:01:12 PM
Backup can not be performed on database 'sfa'. This sub task is ignored.

End of maintenance plan 'sfa backup - tape' on 7/8/2004 12:01:12 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

Emailing report to operator 'Eddie & Steve'

SC

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:VA.00000081.1666e8a8@no-spam.sqldts.com...
> Do you have enough space?
> Have the maintenance plan log to text file.
> Copy and paste the command into QA and execute it there, you should get
> more output that way.
>
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>

Relevant Pages

  • Re: Question about sql job, SQL 7 versus upgrade to SQL 2000
    ... Here's the output from the job, once I turned on the Reporting for it: ... Microsoft SQLMaint Utility, Version Logged on to SQL Server ... 'SISDB2' as 'MYDOMAIN\mylogin' ...
    (microsoft.public.sqlserver.server)
  • Re: Question about sql job, SQL 7 versus upgrade to SQL 2000
    ... Here's the output from the job, once I turned on the Reporting for it: ... Microsoft SQLMaint Utility, Version Logged on to SQL Server ... 'SISDB2' as 'MYDOMAIN\mylogin' ...
    (microsoft.public.sqlserver.dts)
  • Critical Alert Update - W32.Slammer
    ... It's not clear if SQL Server 2000 SP1/SP2 includes the ... Microsoft SQL Desktop ... and all applications that install ... >most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)
  • Re: are ado questions allowed here?
    ... Microsoft re MDAC ... This article describes the past, present, and future of Microsoft data ... * OLE DB (including SQL Server OLE DB Provider, ... will be available on the 64-bit Windows operating system. ...
    (comp.databases.ms-access)
  • Re: Critical Alert Update - W32.Slammer
    ... > It's not clear if SQL Server 2000 SP1/SP2 includes the ... > Microsoft SQL Desktop ... >>most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)