Maintenence Plan

From: BigA (if_possible_at_hotmail.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 03:34:40 -0700

We are running SQL server 2000 on Windows 2000 and have a
number of servers. We have set up scheduled backup
maintenence plans which are set to back our databases,
transaction logs to disk then delete the transaction logs
and backup files after so many days. The backups are
always ok but For some reason the Transaction logs and
backup files are not being deleted which causes the disk
to fill up and databases to crash. We have checked the
permissions on the backup folders to see if the SQL
service account might not have had permissions set
correctly but this is not the case. Can anyone help with
this.

Relevant Pages

  • Backup and locking
    ... We are running SQL Server 2000 on Windows Server 2003. ... We want to run a backup several times during the day - some of these will be ... SQL statement issued through Query Analyser) is performed on the database ...
    (microsoft.public.sqlserver.server)
  • Backup Error - File in Use
    ... I am running SQL Server on a Win 2003 Server box. ... I have a batch file that executes after the ... I am not sure what kind of locks could be set on the backup dat file to ...
    (microsoft.public.sqlserver.server)
  • Re: Backup Error
    ... Can you validate the backup file by restoring it to a diffrent database. ... > I am running SQL Server 2000 Enterprise SP3. ...
    (microsoft.public.sqlserver.connect)
  • Re: MDBDATA folder size
    ... Full online backups normally purges the transaction logs after they are ... the Exchange service was not shut down gracefully and the database files are ... power fail, and so on), and restore after backup. ... Circular logging allows you to remove the logs automatically-This option is ...
    (microsoft.public.exchange.admin)
  • Re: Error in Exchange
    ... play in .edb file or with database and how information is saved into .edb ... You really should try to find the hardware issue first as it will most ... On Oct 6 I again take a full backup of exchange and as you know, ... transaction logs are saved in that backup. ...
    (microsoft.public.exchange.admin)