Question about sql job, SQL 7 versus upgrade to SQL 2000
From: ChrisR (anonymous_at_discussions.microsoft.com)
Date: 07/08/04
- Next message: Allan Mitchell: "Re: Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Previous message: Andrew J. Kelly: "Re: SQL longer in SP than out of the SP"
- In reply to: Goober at christianDOTnet: "Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Next in thread: Allan Mitchell: "Re: Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 8 Jul 2004 08:24:54 -0700
I just realized that I dont need to do anything because
someone else already recreated the jobs. Hope the article
helps.
>-----Original Message-----
>I have a server that until yesterday had SQL 7 on it, and
it ran okay.
>
>However, after upgrading from SQL 7 to SQL 2000, I have
one job that won't
>run. It's a scheduled job to be run each night, and it
kicked out last
>night as soon as it was scheduled.
>
>A "normal" run of the job would give this output:
>
>Output of sqlmaint.exe
>----------------------------------------------------------
------------------
>---------------------------------------
>Microsoft (R) SQLMaint Utility (Unicode), Version 7.00.961
>Copyright (C) Microsoft Corporation, 1995 - 1998
>
>Logged on to SQL Server 'SISDB2' as 'MYDOMAIN\mylogin'
(trusted)
>Starting maintenance plan 'sales backup - tape' on Wed
Jul 07 03:00:02 2004
>
>End of maintenance plan 'sales backup - tape' on Wed Jul
07 03:00:02 2004
>
>SQLMAINT.EXE Process Exit Code: 0 (Success)
>(10 rows(s) affected). The step succeeded.
>
>The "bad" run's output was:
>
>Executed as user: MYDOMAIN\mylogin. sqlmaint.exe failed.
[SQLSTATE 42000]
>(Error 22029). The step failed.
>
>I checked the space on the drive, and it was under 10
gigs. I've created
>some space, but don't know if that's enough.
>
>>From what I understand, I want to run a DBCC
SHRINKDATABASE manually on it,
>but don't know if space is my main problem.
>
>The TSQL that was actually running was:
>
>EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>669422CD-7916-11D4-95F6-00A0C9B148AA -WriteHistory -
VrfyBackup -BkUpMedia
>TAPE -BkUpLog "\\.\Tape0" '
>
>Any ideas as to what I might need to do to get this to
run?
>
>So far, that has been the only unknown hiccup in
upgrading to SQL 2000.
>
>Any help/advice appreciated.
>
>SC
>
>
>
>.
>
- Next message: Allan Mitchell: "Re: Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Previous message: Andrew J. Kelly: "Re: SQL longer in SP than out of the SP"
- In reply to: Goober at christianDOTnet: "Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Next in thread: Allan Mitchell: "Re: Question about sql job, SQL 7 versus upgrade to SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
