I have been thrown into doing some SQL work which i am not a pro at. I have a script setup to backup the database to a file called Backup.bak on a network location. Everything works fine BUT it keeps adding the backups to the Backup.bak file so it keeps
growing larger and larger. I only want to keep 7 ays worth of backups for this particular script. My question is how can i use the script to keep only 7 days worht of backups and keep the backup.bak file from growing and growing. Right now i have to go in
and delete the file every 7 days for it to start over, if i dont the backup file gets really really big.
View Complete Post