sql server 2005 - How can I enforce expiry day in SQL backup append? -


If I do database backup, where I set Expire day = 2. How do I delete backup sets older than 2 days? I am using SQL 2005 Express, so everything runs as a script. This script is running:

Backup database from [database name] to disk = N'C: \ Temp \ DatabaseName.bak 'with Retents = 2, NOFORMAT, NOINIT, NAME = N'DatabaseName-Full Database Backup ', Skip, Norwind, Shipping, Status = 10 Geo

After 5 days I have 5 backup sets. I will fill this disk ....

Thanks

There is no one way you can do it with the Express Edition, along with any SQL Agent job scheduling head There is no Swiss. For comparison, please see if you need to adjust it or create a batch script to upgrade the version.


Comments