Re: backup log <my database> with no_log

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 15:35:04 +0100

The big question is why do you do a BACKUP LOG dbname WITH NO_LOG in the
first place? I can't think of a normal environment where you want to do
this.

(No, you can't make SQL Server *not* write this event, btw...) 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"myoav" <yoav.maimon@verint.com> wrote in message
news:764401c406ab$06123f90$a601280a@phx.gbl...
> im running sql agent job that backups database with "full"
> recovery model. the last step of job is : backup log <my
> database> with no_log.
>
> the job return success but still i'm getting an error in
> the windows event viewer: "Database log truncated:
> Database: <db name>." error 18278
>
> what should i do to avoid this error in the event viewer?
> thanks,
>

Relevant Pages

  • Re: Mystery Table Delete!
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > 29 tables in our live database were deleted the other day ... > We have found an entry in Application Event Viewer that ... > I understand that this is saying that the command failed, ...
    (microsoft.public.sqlserver.server)
  • Re: SQl Writer Service Hangs
    ... I've collected this informaton from Event Viewer. ... If you are prompted for an administrator password or for a confirmation, ... You don't have MS SQL Server running on the computer, if you don't know what it is or you shouldn't have it on the machine. ... The database in 99.9% of the time would be used by a software developer to develop software solutions on the computer that would use MS SQL Server as the database, which would be the reason that MS SQL Server would be installed on a computer. ...
    (microsoft.public.windows.vista.general)
  • Re: DB SUSPECT
    ... Is there anyway i can get back those missing records in one table. ... > BACKUP LOG dbname TO ... ... > Tibor Karaszi, SQL Server MVP ... >> Our server has a power-outage and when it came back one of the database ...
    (microsoft.public.sqlserver.security)
  • backup log <my database> with no_log
    ... im running sql agent job that backups database with "full" ... the last step of job is: backup log <my ... what should i do to avoid this error in the event viewer? ...
    (microsoft.public.sqlserver.programming)
  • Re: Still problems with space
    ... Can you tell me the File growth mentioned for Transaction log file. ... IN Enterprise manager -- Select Databases -- Right click above the database ... Backup the transaction log (Use BACKUP Log dbname to ... Shrinking the Transaction Log in SQL Server 2000 with DBCC ...
    (microsoft.public.sqlserver.server)