Transaction logs

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

Hi,

I have a database, recovery model full.

I have a maintenance plan that does a full backup everyday at 6:00
PM. I also have another plan that does only transaction log backups
every hour during business hours.

My question is, when is it safe to delete the old logs? Never? After
the full backup? I think it would be safe to delete logs older than
the last full backup, but I want to be sure.

Thanks
Andy

.

Relevant Pages

  • Re: Database Maintenance Plan Problems
    ... >may want to create separate maintenance plans for the system databases such ... Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan ... >A maintenance plan job to backup transaction logs may fail. ...
    (microsoft.public.sqlserver.server)
  • Re: Mantanace Plan not deleting old files
    ... The problem I had was someone set up a maintenance plan to backup ALL ... > account is the security context for jobs, ... > and ensure the SQLServerAgent startup account has Full Control. ...
    (microsoft.public.sqlserver.server)
  • Re: Full vs Simple Database Model?
    ... How do the individual steps of the maintenance task on the test database ... I simply restore from a backup. ... I note that you don't rebuild the indexes on the test ... the maintenance plan for the Live system consists of: ...
    (microsoft.public.sqlserver.setup)
  • Re: Database Maintenance Plan Problems
    ... the system databases such ... Deleted by Maintenance Plan ... >>A maintenance plan job to backup transaction logs ... >>Backup can not be performed on this database. ...
    (microsoft.public.sqlserver.server)
  • Re: Maintenance Plans
    ... This is likely to be either a permissions problem or a sharing violation ... account is the security context for jobs, and thus the maintenance plan. ... delete an expired backup. ...
    (microsoft.public.sqlserver.server)