Red Gate forums :: View topic - File Management / File Name Format
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

File Management / File Name Format

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



Joined: 19 Jul 2006
Posts: 17
Location: Allentown, PA, USA

PostPosted: Wed Nov 07, 2012 7:11 pm    Post subject: File Management / File Name Format Reply with quote

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?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Thu Nov 08, 2012 9:13 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
LehighDBA



Joined: 19 Jul 2006
Posts: 17
Location: Allentown, PA, USA

PostPosted: Thu Nov 08, 2012 10:09 pm    Post subject: Reply with quote

That was it. Thanks! Very Happy

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.
Back to top
View user's profile Send private message
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