Re: SQL SERVER 2005 BACKUP / MAINTANCE PLAN PROBLEM

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

Hi
I have solved the problem, It was because of rows flow charts between tasks,
I didnt know that I must use rows in order to connect plan tasks each other,
after using them and selecting / complete, success It worked....

ILKER SOGUT

"ILKER SOGUT" <ilkersogut@xxxxxxxxx> wrote in message
news:eTKNxFnMHHA.448@xxxxxxxxxxxxxxxxxxxxxxx
Hi Everybody,
I have a problem at my SQL Server, SQL Server Version is 2005, I have
scheduled a job, ( Maintance Plan ) To backup all database every day at
02:00 AM, to disk, and I also done the setting " delete old backup files
(*.bak) older than 2 days." But The SQL Server never deletes old backup
files, they are getting too much size on the disk, so I must delete old
backup files manually.

Is there any one who meets the same problem and knows the solution ?

Thanks a lot ..


ILKER SOGUT



.

Relevant Pages

  • Database Maintenance Plans
    ... I am running a Database Maintenance Plan using SQL Server ... not remove any backup files period so that they stack up ... the Plan will then begin removing the ...
    (microsoft.public.sqlserver.setup)
  • Re: Database Maintenance Plans
    ... I support the Professional Association for SQL Server ... > 2000 on a Windows 2000 server and it runs perfectly other> than the fact that at randomit stops removing> backup files older than 1 day. ... I have verified that the> Plan is set to remove files older than 1 day, yet it will> not remove any backup files period so that they stack up> and use up all our disk space. ... the Plan will then begin removing the> old backup files like it is set to do. ...
    (microsoft.public.sqlserver.setup)
  • Re: corrupted backup file
    ... is not automatic recovery work to be done, and SQL Server know that, SQL Server can re-create a ... Restore your latest clean backup or open a case with MS and see if they can help ... If that doesn't work and your backup files are corrupt, ...
    (microsoft.public.sqlserver.server)
  • 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: Cant find log-shipping option
    ... I looked at a couple and simply went for the market leader on the assumption ... that they were less likely to go bust:) ... hand-crafted as SQL Server won't recognise the backup files. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)