What are the challenges you face when working across database platforms? Take the survey
Options

Backup file name for red-gate

soonyusoonyu Posts: 8
edited October 18, 2006 5:30AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.