Activity overview
Latest activity by Marianne
Tell us what you think about SQL Doc
We're working on the next version of SQL Doc and would like to find out more about how you use the product. You can suggest and vote for improvements to the product on the SQL Doc Uservoice forum....
SQL Backup 7.3.2.3
The latest version for SQL Backup is 7.3.2.3. The latest version of the server components is 7.3.2.12. This is a patch release to fix the following problems:
-SB-5468 - Including WITH COPYTO_HOSTED...
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...
SQL Backup 7.3.1.1
The latest version for SQL Backup is 7.3.1.1. This is a patch release to fix a problem in the Activity History which causes it to load much more slowly than usual, or to fail to load, after upgradi...
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...
SQL Backup 7.3
We’re pleased to announce that SQL Backup 7.3 has been released and is available to download. This is a minor release and includes new features and bug fixes.New features
• Upload a copy of bac...
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...
Hi
No, I'm afraid it's not possible to restore more than one database at a time.
Cheers,
Marianne / comments
Hi
No, I'm afraid it's not possible to restore more than one database at a time.
Cheers,
Marianne