Useful for Idera SQLSafe backups. Great software but the GUI and maintenance plan generation are a little quirky. You can easily modify this for Full, Log, Encryption, etc. - Example:
EXEC usp_SS_FullBackup @dbsvrname='YOURSERVERNAME',@dbname='Northwind',@path='C:\Northwind_Full_',@description='Full Backups for Northwind'
Using the FORFILES Command to Delete SQL Server Backups
Is there a way I can automate a file deletion process from within SQL Server?
2008-11-11
4,819 reads