Backup file name for red-gate

soonyu

As we know, we can backup sql db with predefine file name or use "auto" in sql command where file name will be
FULL_servername_dbname_20061018_150407.sqb

2 question
1. is that anyway to change to backup file name limte to yymmdd only? without the hours, minutes, second

2. If we use script to change the file name each time the sqlbackup running. example
Fullbackup_servername_dbname_Monday
Fullbackup_servername_dbname_Tuesday
Fullbackup_servername_dbname_Wednesday

and when we running backup with "ERASEFILES = 7". will the file still delete correctly?

Thanks

petey

The <AUTO> naming convention can be changed using the GUI. Look in the Options screen, on the Backup Location tab, the 'File name format' value.

The deletion process works something like this:

- SQL Backup obtains a list of all the files in the folder
- for each file, compare the server, database and backup type
- if they match, and the age of the file is past the entered age, the file is then deleted

So yes, the deletion will still happen, given your scenario. The name of the file is not critical.