Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 124
sql 123
ms sql server 118
ms sql 117
database 108
tsql 80
#SQL Server 78
t-sql 74
#sql 71
sql server general 66

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

SQL Server - Archive old database backup files using TSQL Script

Jan 7 2012 12:00AM by Paresh Prajapati   

I experienced into one issues for database backups were failed. And this was due to space issues on disk drive. This disk drive is spacific to allocated for the database backups only. The space was eaten by this database backups and this drive contains so many old backups. I have manually deleted all files and continue this activity so many days.If you create a maintenance plans then it have option to delete old backups files. But i have the stored procedure for the database backups. So i do not have option to delete old and unused database backup files.

Continue Reading...

Tags: sql, tsql, sql server, ms sql, ms sql server, t-sql, #SQL Server, #sql, database, sql server general, Maintenance, SQL Scripts, backup, query,


Paresh Prajapati
6 · 23% · 7533
3 Readers Liked this
Paresh Prajapati Liked this on 1/7/2012 7:42:00 AM
Profile · Blog · Facebook · Twitter
Jacob Sebastian Liked this on 1/20/2012 9:03:00 PM
Profile · Blog · Facebook · Twitter
Nirav Liked this on 3/28/2012 12:28:00 AM
Profile · Blog · Facebook · Twitter
3
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

1  Comments  

  • Hi .. I like the script and i tried on my local machine. but is there anyway where i can apply UNC path and deletes 7 days old T-log backup files?

    commented on Jan 20 2012 1:23PM
    Ankit Shah
    297 · 0% · 147

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Archive old database backup files using TSQL Script" rated 5 out of 5 by 3 readers
SQL Server - Archive old database backup files using TSQL Script , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]