Comments
Sort by recent activity
Hi,
We have released a patch to address this issue, version 7.3.1.1. You can download this using Check for Updates (from the Help menu in the SQL Backup GUI) or by downloading the installer from the SQL Backup page.
If you have already upgraded to SQL Backup 7.3, you will not need to upgrade your server components again.
Thanks,
Marianne / comments
Hi,
We have released a patch to address this issue, version 7.3.1.1. You can download this using Check for Updates (from the Help menu in the SQL Backup GUI) or by downloading the installer from th...
Hi Alex,
Thank you for raising this. This is a known issue in SQL Backup 7.3 (reference SB-5459) whereby the result of copying a backup to a network share is not reported correctly in the Activity History and Backup Properties if the VERIFY option is also applied to the backup. When backing up multiple databases with both these options (COPYTO and VERIFY), the results of copying the backup to a network share are not reported for the first database in the set.
I'm very sorry for the confusion this is causing you. We are currently working on the next release of SQL Backup, which will replace the installer. This bug should be addressed in a subsequent release of SQL Backup.
I hope that helps. Please get in touch if you need more information.
Thanks,
Marianne / comments
Hi Alex,
Thank you for raising this. This is a known issue in SQL Backup 7.3 (reference SB-5459) whereby the result of copying a backup to a network share is not reported correctly in the Activity ...
Hi Luis,
Thanks for your post. I'm not sure I have understood your question correctly. Do you mean, is it possible to overwrite a backup in a SQL Backup Pro Hosted Storage account by uploading another backup with the same name? The answer to this is no: the upload timestamp is appended to the backup file name, ensuring that each file in a hosted storage account has a unique file name. This means that you can upload multiple backups of the same name (eg "mybackup.sqb") to a Hosted Storage account without overwriting older files.
I hope that answers your question. Please let me know if you need more information.
Thanks,
Marianne / comments
Hi Luis,
Thanks for your post. I'm not sure I have understood your question correctly. Do you mean, is it possible to overwrite a backup in a SQL Backup Pro Hosted Storage account by uploading anot...
Hi Chris,
The verify issue concerned scheduled backup jobs hanging when WITH VERIFY was included in the backup command. The backup was written to disk, but the RESTORE VERIFYONLY process did not complete, causing the job to hang.
I hope that helps. Please let me know if you need more information.
Thanks,
Marianne / comments
Hi Chris,
The verify issue concerned scheduled backup jobs hanging when WITH VERIFY was included in the backup command. The backup was written to disk, but the RESTORE VERIFYONLY process did not co...
Hello,
Yes it is possible to copy a backup to more than one location. You will need to edit the backup script, as this option is not available in the Back Up or Schedule Backup Jobs wizards. You can copy the script from the last step of the wizard, then edit and run it from SQL Server Management Studio.
To copy a backup to another location, add COPYTO = '\\location\backups' to the WITH clause of the BACKUP command. You can include multiple COPYTO options to a BACKUP command. For example:
execute master..sqlbackup '-sql "BACKUP DATABASE ''AdventureWorks'' TO DISK = ''c:\Backups\<AUTO>.sqb'' WITH COPYTO = ''\\servername\dbbackups'', COPYTO = ''\\otherservername\dbbackups'' " '
The SQL Backup Agent service must have permission to write to the COPYTO locations.
More information on the COPYTO option is available here: http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.2/SBU_BACKUP_cmd
I hope that helps.
Cheers,
Marianne / comments
Hello,
Yes it is possible to copy a backup to more than one location. You will need to edit the backup script, as this option is not available in the Back Up or Schedule Backup Jobs wizards. You ca...