suitable plan for Log backup

From: Aryan (Aryan_at_discussions.microsoft.com)
Date: 07/11/04 

Date: Sun, 11 Jul 2004 08:04:01 -0700

Hi,

I have a 2GB database and the size of log file is approximately 1.5GB. For backup, I have defined a maintenance plan for DB & Log files. Unfortunately, after backup the size of log file does not decrease. It is said that after log file backup, SQL server eliminate the inactive logs automatically.
What is the best plan for Backup in SQL server? I mean, a plan for backup of DB/Log files and also we can have a log file in a suitable size.

Thanks in advance

Aryan

Relevant Pages

  • Re: Sql 2000 Maintenance Plan not deleting old transaction logs
    ... Did you include any databases in simple recovery in that plan? ... account is the security context for jobs, ... delete an expired backup. ... I'd rather not have to delete these extra backup files manually or with an extraneous script. ...
    (microsoft.public.sqlserver.tools)
  • Re: Which PC for maximum reliability?
    ... the operating system has any relevance when designing emergency ... building collapses (and your treasured backup DVD are gone with it)? ... That depends what you mean by backup plan. ... that designing a failure-tolerant computer system is way ...
    (rec.photo.digital)
  • Re: Which PC for maximum reliability?
    ... Do you need to be covered in case the building collapses (and your treasured backup DVD are gone with it)? ... That depends what you mean by backup plan. ... that designing a failure-tolerant computer system is way beyond the skills of even most computer experts. ... And balancing business needs with cost for e.g. finding the most cost-efficient option for distributed offsite data backup storage or options for system replacement from hot-swappable where a standby system just takes over with even the same IP-address to just order a new computer and reinstall everything is a challange even for experts. ...
    (rec.photo.digital)
  • msdb refuses to back up w/ plan
    ... I've created a Mx plan for the system databases. ... Part of it is a complete backup. ... See the SQL Server error log for more ... Mx plan would fail for just this one database, when I can back it up ...
    (microsoft.public.sqlserver.server)
  • Re: Backing up SBS 2003 for Disaster Recovery
    ... You will also need a backup with some disaster recover plan on how to use ... Modern backup software gives you specific DR capabilities. ... backup job that backs up the whole server, and then it will provide a CD ... you should test your plan. ...
    (microsoft.public.windows.server.general)