use a template on a different instance

fatherjack2fatherjack2 Posts: 311
edited April 14, 2008 7:27AM in SQL Backup Previous Versions
Hi,

Is it possible to transfer, or otherwise make available, a template for a backup job between different SQL Servers and SQL Server instances?

I have created several job templates on Server1\SQLInstance1 and and a couple of them are relevant to SQLServer2\SQLInstance2 but I cannot see a method to make them available to speed up the job creation process...


TIA

Jonathan

Senior DBA
Careers South West Ltd

Comments

  • Jonathan,

    Thank you for your forum post.

    SQL Backup templates are stored in the following registry key :

    HKLM\SOFWARE\Red Gate\SQL Backup\BackupSettings\<instance name>

    These registry entries can be transferred to work on other instances/servers.

    I hope this helps.
    Matthew Flatt
    Redgate Foundry
  • Thanks Matthew, i have the templates moved over.

    Maybe this process is a potential development for the next version? Using the SQL Backup GUI would have been a lot easier as i can see all my servers from there...

    cheers

    Jonathan

    Senior DBA
    Careers South West Ltd
  • Jonathan,

    I have created an internal feature request on your behalf, for your information the reference for this is : SB-3470

    I will reply to this thread when the request has been reviewed and updated.

    Thanks,
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.