SQL Backup Log File name

toad2898toad2898 Posts: 41
edited March 7, 2013 9:36PM in SQL Backup Previous Versions
Is it possible to change its name from the default? doesnt seem to be an option in the UI.

thanks
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    No, it isn't possible to change the log file name. For backups, the GUID that forms part of the file name represents the backup_set_uuid value in the msdb..backupset table, to allow easy referencing with the SQL Server backup history tables.

    It is possible to change the folder though, and you can use tags. E.g. if you wanted to separate the log files by database name, you could use

    g:\sql backup\logs\<INSTANCE>\<DATABASE>\
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.