Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mchohan
Starting Member
39 Posts |
 Posted - 2010-08-24 : 09:44:02
|
| Hi,I want to backup each day however, I only want to keep backup files that are less than 7 days old. Therefore, there should not be more than 7 backup files in my backup folder.Without creating a vb script to delete old backup files, does anyone know another way using the backup facility in sql server?Thanks, |
|
|
mchohan
Starting Member
39 Posts |
Posted - 2010-08-24 : 09:53:21
|
| Ahh looks like I anwsered by own question after submitting the problem, I can use SSIS for this task.thanks. |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-24 : 11:39:02
|
| SSIS can do your task very neat and easy. just use a convention (either using 7 folders, each for one day) or a naming convention. after you are done constructing SSIS, just use the job and schedule it daily, weekly to delete unneccessary files. |
|
|
|
|
|
|
Rolling Backups