Post reply

Backup file issue

  • February 6, 2009 at 9:34 pm

    #127442

    Hi,

    I have configured daily backup through maintenance plan, backup schedule every 12:00 AM, and remove the old 1 day files from backup directory, Backup was taken daily, but issues old backup file was not deleted automatically.

    plz tell me, what actual issues?

    thanks

  • February 6, 2009 at 9:36 pm

    #939892

    What version of SQL Server, what service pack?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • February 6, 2009 at 9:45 pm

    #939895

    Thanks for reply david.

    Sql server 2000.

    product version -8.00.2039

    service pack - sp4

    os- windows server 2003 enterprise edtion

    thanks

  • February 6, 2009 at 9:50 pm

    #939896

    Kind of hard to tell. Did the backup job fail due to lack of space? Ultimately the backup will occur first then the old file will be deleted - or should be anyway.

    Being that it is a maintenance plan it's pretty hard to look through from here. You might want to make sure that all the paths are correct for file locations and if nothing stands out to you try to rebuild the maint plan and see what happens.

    Sorry can't help more...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • February 10, 2009 at 9:55 pm

    #941789

    Hi,

    We have got enough disk space in Drive.

    Again i have re-build maintenance plan for bakup but i was not hope,

    Re create new plan again same problem happend. 1 day old file was not deleted from backup folder.

    Every day SQL server maintenance plan backup was taken successfully but 1 days old file was not deleted automatically from backup folder as per maintenance backup plan, so D drive getting full within 2 days.

    Total space in D Drive 79gb

    free space 39gb

    per day backup size - 22 gb

    thanks

  • February 10, 2009 at 10:01 pm

    #941790

    Do you have logging set up for the maintenance plan? It's on one of the last tabs and you can log to a disk file.

    Make sure you have rights for the SQL Agent account to delete files. It's possible that those rights don't exist on the file system. The other issue is a failure somewhere in the maintenance plan. The way it works is that it runs all the backups, then runs the maintenance, then deletes old files. If it fails on some other backup, the files won't be deleted.

  • February 10, 2009 at 10:19 pm

    #941807

    Thanks jones for your reply.

    Now i got the exact problem. This server have 24 production database, as per maintenance plan taking backup for all 24 databases, last day one database failure due to disk space, it was taken backup 23 databases. so we should consider to increasing free space on drive.

    thanks

  • February 10, 2009 at 10:22 pm

    #941811

    You are welcome and glad you found the issue.

    As a general rule, for production, be sure you have enough space for 2 backups of all databases. These should be on separate drives from data, even USB drives, to be sure that if the data drive fails you don't lose your backups. This also allows you to take a new backup before removing the old one.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply