Comments
Sort by recent activity
We are experiencing this problem as well. Is the SQL Backup download version 3.2.0.5? The readme file only says 3.2.0 / comments
We are experiencing this problem as well. Is the SQL Backup download version 3.2.0.5? The readme file only says 3.2.0
This post is to follow-up on this thread and to close it out. What we decided to do was to remove the /3gb from the SQL Server. This SQL Server has 16 gig of RAM and we do have it configured to use AWE. According to Microsoft, servers with more than 16 gig of RAM don't need the /3gb switch and since we had 16 gig we decided that it was OK to go ahead and remove the switch. This action did reduce the over all amount of memory that SQL Server was using and that impacted the buffer cache mostly but the hit ratio did not go down so I think that we are ok. The Network Admins attempted to retrieve the sector size where we are storing the backups but they were unable to get that information with the equipment we are using. With the /3gb switch in place we were seeing any DB over 1 gig in size fail. So far the backups are running fine. We were previously using SQL LiteSpeed to backup our databases and we never had this problem. I would like to see this problem resolved in the next release of SQL Backup because it may not be an option to remove the /3gb switch with the next SQL Server that we deploy SQL Backup to. / comments
This post is to follow-up on this thread and to close it out. What we decided to do was to remove the /3gb from the SQL Server. This SQL Server has 16 gig of RAM and we do have it configured to u...
It does seem that SQL Compare tries to decrypt each encrypted object, is there anyway to turn off this feature. All our QA, UA and production servers will have encrypted objects (SP's, views, UDF's, triggers). As it stands now, we will not be able to use SQL Compare against any of these servers. / comments
It does seem that SQL Compare tries to decrypt each encrypted object, is there anyway to turn off this feature. All our QA, UA and production servers will have encrypted objects (SP's, views, UDF's...
We are using 3.2.0 according to control panel which agrees with what is printed in the backup logs. I take it that this is not the same as 3.2.0.5. I will look for this version on the website. / comments
We are using 3.2.0 according to control panel which agrees with what is printed in the backup logs. I take it that this is not the same as 3.2.0.5. I will look for this version on the website.
Thank you for the tip. I was thinking along the same lines as you.
I think my best option is to embed the hour in the same of the file and use the INIT option for each backup run. This should give me a set of 10 log backup files that are reused from day to day (backing up every 2 hours from 4 am until 12 am).
Thank you for your help on this.
Donald Weigend / comments
Thank you for the tip. I was thinking along the same lines as you.
I think my best option is to embed the hour in the same of the file and use the INIT option for each backup run. This should give...
Thanks for the reply.
My log backup job runs every two hours from 4 am until 12 am. So with SQL Backup I will create a new file each time this job runs. I don't suppose there is an option to make SQL Backup add something to a backup file name so they will be unique? Ideally I would like to have a rotating set of files that will get reset with the 4 am log backup then I will not have to worry about deleting old log backups once I take a new full backup. Not being able to append to a single log backup file throughout the day is definitely a drawback to an otherwise very good product. Is this function being considered for future releases of SQL Backup, if not, how can I get it on the list.
Donald Weigend / comments
Thanks for the reply.
My log backup job runs every two hours from 4 am until 12 am. So with SQL Backup I will create a new file each time this job runs. I don't suppose there is an option to make...
I have the log file recorded during the install. How can I ship this to you? I realy don't a way to attach files from this forum.
Don Weigend / comments
I have the log file recorded during the install. How can I ship this to you? I realy don't a way to attach files from this forum.
Don Weigend
I sent the log file to the email address you provided. The file is called log.txt.
Thanks for all your help so far.
Don Weigend
Wonderbox Technologies, LLC / comments
I sent the log file to the email address you provided. The file is called log.txt.
Thanks for all your help so far.
Don Weigend
Wonderbox Technologies, LLC
Brian Donahue wrote:
Hello Don,
There is no problem running SQL Backup on a virtual machine. We test this software thoroughly against Microsoft Virtual Server and VMWare workstation, so if there was an interaction problem with the software, we would definitely know about it.
More than likely it's a problem in RedGate's licensing tool that runs during the installation. And more often than not this happens because a cryptographic machine key could not be created or accessed. On Windows 2000/2003/XP, you'll want to check your rights to %ALLUSERSPROFILE%\Application Data\Microsoft\Crypto folder to make sure you can read and write to the RSA MachineKeys folder.
I am using an account that is part of the local administrators group and I checked the rights for the Crypto folder as suggested and it looks proper to me but I still get a failure on the install. I also tried changing the rights to this folder so everyone had full control but that did not help either. Any other ideas? / comments
Brian Donahue wrote:
Hello Don,
There is no problem running SQL Backup on a virtual machine. We test this software thoroughly against Microsoft Virtual Server and VMWare workstation, so if there...
Brian Donahue wrote:
Can you please try logging the install?
You can pass arguments to the installation like this:
SQLBackupSetup /V"/l*v c:\InstallLog.txt"
This will create a text file that audits all of the actions of the installer and will show which program 'couldn't be run' as part of the install.
Are you sure about the syntax for the switches. I get an error when I attempt to use them. I tried this using the command line as well as in the properties of the setup file. / comments
Brian Donahue wrote:
Can you please try logging the install?
You can pass arguments to the installation like this:
SQLBackupSetup /V"/l*v c:\InstallLog.txt"
This will create a text file that...