Red Gate forums :: View topic - SQL Backup Log File name
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

SQL Backup Log File name

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Thu Mar 07, 2013 1:36 pm    Post subject: SQL Backup Log File name Reply with quote

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

thanks
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Fri Mar 08, 2013 3:36 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group