How can we help you today? How can we help you today?

Backup file name for red-gate

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
soonyu
0

Comments

1 comment

Sort by
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.