Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Want to delete sql backup and log files for the last one month Expand / Collapse
Author
Message
Posted Sunday, January 12, 2014 12:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 5:50 AM
Points: 2, Visits: 4
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
Post #1530079
Posted Sunday, January 12, 2014 12:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:35 AM
Points: 3, Visits: 234
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?
Post #1530080
Posted Sunday, January 12, 2014 3:06 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, March 30, 2014 11:40 AM
Points: 459, Visits: 256
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
Post #1530084
Posted Sunday, January 12, 2014 3:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 5:50 AM
Points: 2, Visits: 4
Dear All,
Thanks for your reply. To be precise disk is getting full. And How do i shrink the log files.

Regards,
Akram
Post #1530086
Posted Sunday, January 12, 2014 8:26 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, March 30, 2014 11:40 AM
Points: 459, Visits: 256
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
Post #1530103
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse