Activity overview
Latest activity by aarons44
Thanks for the reply. Honestly, we were thinking about dropping RedGate when we moved to SQL 2008, because Microsoft is implementing compression and encryption finally, but they can't do both at the same time, which made me a little curious. Between the great support we get from RedGate, and the features of the product, we just renewed our licenses for another year. / comments
Thanks for the reply. Honestly, we were thinking about dropping RedGate when we moved to SQL 2008, because Microsoft is implementing compression and encryption finally, but they can't do both at th...
Is this true encryption of the entire file? I'm just a little skeptical, since Microsoft can't make encryption and compression work together in SQL Server 2008. / comments
Is this true encryption of the entire file? I'm just a little skeptical, since Microsoft can't make encryption and compression work together in SQL Server 2008.
That is excellent news! / comments
That is excellent news!
Encryption with Compression
Are the encryption and compression options mutually exclusive? I assume they are, since they always are in other software packages due to the nature of the two operations, but I wanted to confirm.
Mostly business driver. We have white papers that we present to our customers that detail the security measures we employ in our operations. The savvy customer sees the section on FIPS security, and asks if we are using FIPS certified products or products that use FIPS approved algorithms, knowing that a poor implementation of a secure algorithm can be worse than a good implementation of a more secure one. You're far from alone in not having FIPS certification though. Out of 7 products that we use for various tasks that employ encryption, only one is FIPS certified, and it is a VPN concentrator. All of the rest point to their use of AES, the NIST-approved algorithm. Common Criteria has a little better results in terms of number of approved products, but it is also probably much more inexpensive to obtain, compared with FIPS 140. / comments
Mostly business driver. We have white papers that we present to our customers that detail the security measures we employ in our operations. The savvy customer sees the section on FIPS security, an...
FIPS / CC Compliance
Are there any plans to have SQLBackup certified against FIPS 140 or Common Criteria? I know that it is using AES 256, so that's a good start, but it would be nice if the app was certified as well.
Thank you, I will do that.
eddie davis wrote:
Hi,
sorry that you are getting this problem.
A support call has been created for this call. Call Reference F0009695.
Can you please send an e-mail to support@red-gate.com and attach a copy of the SQL Backup Log file for this failing job. SQL Backup creates a log file for each backup/restore job ran. By default the SQL Backup Log File is located in the following directory:
C:\Documents and settings\All Users\Application Data\Red Gate\SQL Backup\Log\(local) or SQL Instance Name.
Also can you please include the call reference in the subject of the e-mail.
Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-Mail: support@red-gate.com
/ comments
Thank you, I will do that.
eddie davis wrote:
Hi,
sorry that you are getting this problem.
A support call has been created for this call. Call Reference F0009695.
Can you please send an e-mail to...
Threaded Backups and SQLBACKUPC
I recently changed my backups to use multiple threads. The backup files are copied to another location where they are restored automatically by a script that calls SQLBACKUPC. The restore process h...
Thank you for the quick response! So, if I use FILEOPTIONS = 1, it will apply the same delete parameters to both locations? Ok, so I guess my request now becomes that this option be added to the GUI. That's typically how I create all of my jobs if possible, which is why I thought that option wasn't available.
Brian Donahue wrote:
Hi,
Thanks for your feedback. I'd just like to point out that it is possible to have files automatically deleted from a COPYTO location using the FILEOPTIONS parameter in the SQL Backup command.
FILEOPTIONS=1 will apply erasefiles to the primary backup location and any copyto or moveto location simultaneously. FILEOPTIONS=2 will only delete the files if the archive bit is clear (ie they have been backed up to tape).
/ comments
Thank you for the quick response! So, if I use FILEOPTIONS = 1, it will apply the same delete parameters to both locations? Ok, so I guess my request now becomes that this option be added to the GU...
Feature Requests
I have two feature requests for SQL Backup. The first is that more than one instance of the application can run on the server at the same time. We often have administrators logged into the server a...