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: BB (bbychkov_at_hotmail.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 11:15:52 -0700

Can you right-click on the database, select "properties", go to "options"
tab and see what the recovery model is? If it's "simple" change it to
"bulk-logged" and try to run the job again.

"Goober at christianDOTnet" <me@privacy.net> wrote in message
news:uAPpT9dZEHA.2216@TK2MSFTNGP10.phx.gbl...
> I performed a backup of it -
>
> go to Management, select backup, then right click and back up database. It
> completed fine.
>
> If I go back in and add a Database Maintenance plan, I created one that
was
> both an integrity check & a transaction log backup, it appeared to
complete.
>
> Out put of that job was:
>
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'SISDB2' as MYDOMAIN\mylogin (trusted)
> Starting maintenance plan 'Test DB Maintenance Plan - Steve' on 7/9/2004
> 1:45:00 PM
> [1] Database sfa: Check Data and Index Linkage...
>
> ** Execution Time: 0 hrs, 2 mins, 43 secs **
>
> End of maintenance plan 'Test DB Maintenance Plan - Steve' on 7/9/2004
> 1:47:43 PM
> SQLMAINT.EXE Process Exit Code: 0 (Success)
>
> Emailing report to operator 'Eddie & Steve'
>
> I took the same job and edited it, and made it a transaction log backup
> only, and it failed. Output is:
>
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'SISDB2' as 'MYDOMAIN\mylogin' (trusted)
> Starting maintenance plan 'Test DB Maintenance Plan - Steve' on 7/9/2004
> 2:00:01 PM
> Backup can not be performed on database 'sfa'. This sub task is ignored.
>
> End of maintenance plan 'Test DB Maintenance Plan - Steve' on 7/9/2004
> 2:00:01 PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> Emailing report to operator 'Eddie & Steve'
>
> One other question - once I figure out what's going on with this
maintenance
> plan, how can I create a job in the SQL Server Agent Jobs folder to do
this,
> like the original TSQL I posted?
>
> Thanks for the help so far,
>
> Steve
>
>
>
>
>
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:VA.0000008c.04ab3b4f@no-spam.sqldts.com...
> > Have you performed a FULL backup yet on this DB. If not then there is
> > no way a T Log backup will work. The lack of a check is the Full
> > backup tab of your maintenance lans would seem to indicate this as
> > well.
> >
> > Also check your Recovery model <> SIMPLE
> >
> >
> > 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: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)