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

From: BB (bbychkov_at_hotmail.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 10:56:41 -0700

Sounds like recovery model for 'sfa' database is set to "Simple". In this
case transaction log backup is not possible.
Either change recovery model to something else (i.e. bulk-logged or full) or
exclude that database from the job (edit maintenance plan).

BB

"Goober at christianDOTnet" <me@privacy.net> wrote in message
news:%23%23h9EUQZEHA.1652@TK2MSFTNGP09.phx.gbl...
> 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: What is the best practice to create Maintenance Plans
    ... > If master is damaged in some way, for example because of media failure, an ... > With the Simple Recovery model, the database can be recovered to the point ... > Full Recovery or Bulk-Logged Recovery model. ... > Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)
  • What is the best practice to create Maintenance Plans
    ... There is not a definitive answer to the question of which backup is better. ... the database can be recovered to the point ... Full Recovery or Bulk-Logged Recovery model. ... Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)
  • Re: transaction log
    ... It seems your Recovery model set to that database is "FULL". ... So we need to scdule a transaction log backup regularly (atleast hourly ...
    (microsoft.public.sqlserver.server)
  • Re:logfiles grow non-stop in SQL2000
    ... Looks like the recovery model for your database is FULL or BULK_LOGGED.Please change the recovery model for the database to ... If you do not have the 65 G to take a backup or if you do not want the transaction log backup. ... The logfiles for the most frequently-used databases grow non-stop. ...
    (microsoft.public.sqlserver.setup)
  • Re: Question about sql job, SQL 7 versus upgrade to SQL 2000
    ... Sounds like recovery model for 'sfa' database is set to "Simple". ... case transaction log backup is not possible. ...
    (microsoft.public.sqlserver.tools)