11 lines
No EOL
271 B
Transact-SQL
11 lines
No EOL
271 B
Transact-SQL
CREATE OR ALTER PROCEDURE [dbo].[Adm_T_DatabaseBackupFilesDeleteAll]
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
DECLARE @DeleteDate date
|
|
|
|
SET @DeleteDate = DATEADD(DAY, -1, GETDATE())
|
|
|
|
EXEC master.sys.xp_delete_file 0, '/var/opt/mssql/backup/', 'BAK', @DeleteDate, 0;
|
|
END |