Re: Can anyone 'crash course' me in SQL maintenance?

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



Back up the transaction log files regularly to delete the inactive
transactions in your transaction log.http://support.microsoft.com/kb/873235

jas


I do transaction log backups 5 days a week. Something like 50 tlog
backups over a workweek. The filesize grows and grows and grows
regardless.

.

Relevant Pages

  • Re: Need to learn how to develop a Full Backup plan strategy with
    ... If you would need to shrink the transaction log, ... transaction log backups create less strain than fewer, ... transaction log backups in the maintenance plan, ... database, you can afford to have a full database backup on a daily basis. ...
    (microsoft.public.sqlserver.setup)
  • Re: Need to learn how to develop a Full Backup plan strategy with
    ... If you would need to shrink the transaction log, ... transaction log backups create less strain than fewer, ... transaction log backups in the maintenance plan, ... database, you can afford to have a full database backup on a daily basis. ...
    (microsoft.public.sqlserver.setup)
  • High CPU during transaction log backups!
    ... High CPU during transaction log backups! ... I'm having issues with a SQL server where during ...
    (microsoft.public.sqlserver.server)
  • Re: High CPU during transaction log backups!
    ... > High CPU during transaction log backups! ... > I'm having issues with a SQL server where during ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction log backup file size?
    ... there is a maintenance plan with the Reorganize data and index pages ... transaction log backups. ... 1:00am the transaction log backup runs and is roughly 220MB. ...
    (microsoft.public.sqlserver.setup)