Re: Transaction Log Backup Files aren't removed

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

From: Kevin3NF (KHill_at_NopeIDontNeedNoSPAM3NF-inc.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 10:30:43 -0500

Changing them to Full means that you should start backing up their logs as
well. You will now have point-in-time recovery ability for those two, like
you do the others.

please read up on recovery modes in Books Online to get a better explanation
than I can give you. 

-- 
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"DraguVaso" <pietercoucke@hotmail.com> wrote in message
news:OzZdR73UEHA.1952@TK2MSFTNGP12.phx.gbl...
> There were 2 databases in it which had a simpel recovery mode (msdb and
> master). Should I set them to Full? Is there any risk with this involved?
>
>
> "Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23cHXMZvUEHA.1356@TK2MSFTNGP09.phx.gbl...
> > Does the account running the job have delete permissions on the folder
> where
> > the .TRN files are?
> >
> > Does the plan backup more than one database?  If so, are any of the
other
> > databases set to simple recovery mode?
> >
> > -- 
> > Kevin Hill
> > President
> > 3NF Consulting
> >
> > www.3nf-inc.com/NewsGroups.htm
> > www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >
> > "DraguVaso" <pietercoucke@hotmail.com> wrote in message
> > news:u$laReuUEHA.1036@TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I've set up a Database Maintenance Plan for my SQL SERVER Database. I
> > Chose
> > > to remove the Backup and Transaction Log Backup files afetr 3 days,
but
> > the
> > > Transaction Log fiels (*.TRN) aren't deleted after three days.
> > >
> > > The .BAK-files (Compelte Backup) are deleted, but not the .TRN-files,
> > > although they are in the same directory.
> > >
> > > Anybody knows what coudl be the reason for this?
> > >
> > > Thanks a lot in advance,
> > >
> > > Pieter
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: NTDS ISAM DataBase Corruption
    ... Did you tried the recover the corrupted Active Directory process that a gave ... This is brand new IBM Server. ... using symantec livestate recovery. ... Active Directory database is unavailable because it is damaged, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Crash recovery after shutdown immediate?
    ... database stated it wanted a recovery. ... it seems that a crash recovery occured. ... ARCH: Archiving is disabled ... After that, I did a backup, NOT a restore. ...
    (comp.databases.oracle.server)
  • RE: Eseutil and restored database - Jet database errors
    ... database repair (hard recovery). ... It approximately spends 1 hour for 6~8 GB database. ... Please refer to the "Method 3: Restore a Mailbox from Backup to a Recovery ...
    (microsoft.public.exchange.admin)
  • Re: Recover mailbox from old Backup...
    ... I never want to use these database files as a production mailstore. ... run the eseutil check, create a Recovery Store Group, ... I still have all the files from the old Exchange 2003 folder ... > I am running Exchange Server 2003 and the database files are from Exchange ...
    (microsoft.public.exchange.admin)
  • Re: [Info-Ingres] W_DM5061_WRONG_BLOB_LENGTH in verifydb
    ... database and the recovery has simply reproduced this, ... Subject: W_DM5061_WRONG_BLOB_LENGTH in verifydb ... writefailed with operating system error 0 ...
    (comp.databases.ingres)