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

Question

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

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

Hakan Forsberg SSC Enthusiast Points: 175 More actions · Answer 1

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?

Damian Widera-396333 Ten Centuries Points: 1196 More actions · Answer 2

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

akram.khan.ali SSC Journeyman Points: 76 More actions · Answer 3

Dear All,

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

Regards,

Akram

Damian Widera-396333 Ten Centuries Points: 1196 More actions · Answer 4

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