Template default location

nagac · March 3, 2015 10:15AM

Hi

I just started using Red Gate Backup package to backup the Database and I found Template concept to reuse the Backup Options. However I couldn't find the Path of the file where it is created after click on Finish button.

Can some one advise the default path of the Template file.

I am going to use this template in my Custom Batch Script which will be automated everyday to back up the couple of database and then exporting to S3 Bucket.

Thanks

Eddie D · March 4, 2015 11:51AM

Hi

Thank you for your forum post.

It does not save a file in the manner that you are seeking. The template information is stored in a registry in this path:

HKEY_LOCAL_MACHINESOFTWARERed GateSQL BackupBackupSettings&lt;SQL Instance Name&gt;

A new key is created with the name you named the template, whose data value are the backup keywords and parameters.

If you wish you can save a copy of the backup script, on the final step of the backup wizard or scheduled backup job wizard ->select the script tab and then you can copy and save the syntax.

Many Thanks
Eddie

nagac · March 4, 2015 1:37PM

Thanks eddi

I thought it will be saved in physical locations. Anyways that makes sense

Thanks

Template default location

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk