Delete old backup files

A stored procedure and two functions that given a path, a date and a file extension will do one of the following:-Delete all files of the supplied extension in that directory before a certain date.-Delete everything before the last full backup.I use this because disk space is tight and maintenance plans seem to delete old […]

2003-08-21

687 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs

Forums

Stored Procedure Performance Woes... How to get around CURSORS for html gen.

By scarr030

Hi everyone, Working with a stored procedure that is used in an application of...

Any guides for sizing Azure managed instances.

By Sliverlight

Hi All, Has anyone got any tips for sizing a move from VM running...

How to check if NextDay is Holiday (exclude Saturday and Sunday)?

By SQL Server

Hi: We maintain a calendar table with these columns. We have a process which...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers