File Management / File Name Format

Compresses, encrypts, secures and monitors SQL Server backups.

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

File Management / File Name Format

Postby LehighDBA » Wed Nov 07, 2012 7:11 pm

Using 7.2.1.4. Trying to make the File Name Format as shown below.

<SERVER>_<INSTANCE>_<DATABASE>_<TYPE>_<DATETIME yyyymmdd_hhnnss>


No matter what I do (Click Apply, etc.) the information will not stay in the file name format box... it reverts back to the previous information.

What am I doing wrong?
LehighDBA
 
Posts: 17
Joined: Wed Jul 19, 2006 6:53 pm
Location: Allentown, PA, USA

Postby chriskelly » Thu Nov 08, 2012 9:13 pm

It sounds like the user account which is assigned to the SQL Backup Agent service does not have Full Control permissions on the relevant location in the registry to make the change. Adding this should allow the new format to save.

The REG_SZ key is:
HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\<Instance_Name>\\BackupFileName
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby LehighDBA » Thu Nov 08, 2012 10:09 pm

That was it. Thanks! :D

Any way for the UI to detect this issue in the future? Not sure if there is an internal status that the UI is getting to indicate that the registry could not be written to.

Also perhaps it could be included in the help file on the Security Model information, etc.
LehighDBA
 
Posts: 17
Joined: Wed Jul 19, 2006 6:53 pm
Location: Allentown, PA, USA


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests