SQL Backup Log File name

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

SQL Backup Log File name

Postby toad2898 » Thu Mar 07, 2013 1:36 pm

Is it possible to change its name from the default? doesnt seem to be an option in the UI.

thanks
toad2898
 
Posts: 27
Joined: Mon Sep 14, 2009 2:36 pm

Postby petey » Fri Mar 08, 2013 3:36 am

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 7
petey
 
Posts: 2227
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: spthorn and 0 guests