Want to delete sql backup and log files for the last one month

  • Dear All,

    Can anyone suggest me on how to delete the last one month backup and log files as my database is getting full more oftenly every month.

    Regards,

    akram

  • Hi,

    What do you mean by database getting full? Is it the transaction log file that is full or the disk where all the backup files are located?

  • Despite the question is not so precise :). We do not know what do you mena by 'database is full'. Maybe you think of it as a 'disk is full'?

    About backups -

    You should leave the last full backup and all backups done after the last full backup

    The older backup than the last full backup could be deleted

    Kindest Regards,

    Damian Widera
    SQL Server MVP,
    MCT, MCSE Data Platform, MCSD.NET

  • Dear All,

    Thanks for your reply. To be precise disk is getting full. And How do i shrink the log files.

    Regards,

    Akram

  • I think yuo should plan your SQL Server installation in such way that log shrink is never needed (ok in some extreme cases - yes)

    So - if your database is in Full recovery mode do a full backup and log backup. This will allow you to shrink log by using DBCC SHRINKFILE command

    Kindest Regards,

    Damian Widera
    SQL Server MVP,
    MCT, MCSE Data Platform, MCSD.NET

Viewing 5 posts - 1 through 4 (of 4 total)

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