We are using SQL Server2005 Enterprise edition.
In our production server DB backup to tape will be occerred at the wkend(i cannot confirm the day) . Once the DB backups to tape are completed i want to delete the old backup files from a particular directory. How i can achieve this.
Can any one suggest that how to identify that files are copied to tapes. If i am able to find this i think we can go with maintanace wizard or may be with the script.
Please suggest me that which one is the best.
Waiting for valuable replies.
View Complete Post