Comments
Sort by recent activity
Hi,
Your serial number is included on your invoice. You can also view which serial number you are using on a particular server from within the app, by opening the UI, selecting the server, then selecting Deactivate license from the Actions menu. The Deactivate serial numbers dialog will open and displays the serial number you are using on that server. Click Cancel if you don't want to deactivate that serial number.
You can also retrieve your serial numbers by going to http://www.red-gate.com/myserialnumbers and entering your email address and password.
Once you have found your serial number, you can use our Upgrade Center (http://www.red-gate.com/Dynamic/UpgradeCenter/SerialNumberEntry) to find out if you have a support and upgrades license, and the cost of upgrading if you don't.
Alternatively, contact us at dba.info@red-gate.com and we can look up the details for you.
Cheers,
Marianne / comments
Hi,
Your serial number is included on your invoice. You can also view which serial number you are using on a particular server from within the app, by opening the UI, selecting the server, then sel...
Hi,
As you say, SQL Backup is licensed per server. If your current v6 licenses include support and upgrades, you can upgrade to v7 for free. To do this, upgrade to the v7 trial, then use your existing serial number to activate the license.
If you do not want to upgrade the server components, you can still register the servers with v6 server components in your SQL Backup v7 user interface. (See http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.0/SBU_RegisterServers for instructions on how to do this.) An icon will be displayed to indicate that the server components do not match the version of the UI. You will still be able to perform backup and restore operations on these servers from the v7 UI, although some features will not be available (this is indicated in the wizards). You can also restore backups taken with v6 on servers running v7 and vice versa. See http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.0/SBU_UpgradingSQLBackup for more information.
I hope that helps.
Cheers,
Marianne / comments
Hi,
As you say, SQL Backup is licensed per server. If your current v6 licenses include support and upgrades, you can upgrade to v7 for free. To do this, upgrade to the v7 trial, then use your exist...
Hi Chris,
Thanks very much for the suggestion. We will post details of the latest releases, and the bug fixes they include, on this forum.
Cheers,
Marianne / comments
Hi Chris,
Thanks very much for the suggestion. We will post details of the latest releases, and the bug fixes they include, on this forum.
Cheers,
Marianne
Hi,
Selecting the 'Filegroups or files' option in the Back Up or Schedule Backup Jobs wizards will create a full filegroup backup.
To take a differential filegroup backup, add WITH DIFFERENTIAL to the BACKUP command. There isn't an option in the wizards to take a differential filegroup backup, but you can include this option in the extended stored procedure or command line instruction. If you want, you can use the Back Up wizard to generate the BACKUP command without running it:
- Select the relevant options to take a filegroup backup of the relevant files of your database.
- Copy the command (either as an extended stored procedure or command line instruction) from the script tab on the final step of the wizard, then cancel the wizard so that you don't take the backup yet.
- Edit the command in an application such as Management Studio to add WITH DIFFERENTIAL (or any other options you require).
- Execute the command.
If you are creating a scheduled backup job, you can create the job using the Schedule Backup Jobs wizard, then edit the job in Management Studio to add WITH DIFFERENTIAL to the BACKUP command (you may want to edit the job name from the wizard so you can find it easily in Management Studio). If you need to edit the job again, you can use the SQL Backup GUI - any additional options which are not supported by the GUI (such as WITH DIFFERENTIAL for filegroup backups) will be preserved but not editable.
More information on the BACKUP command syntax is available here: http://www.red-gate.com/supportcenter/C ... BACKUP_cmd
I hope that helps.
Thanks,
Marianne / comments
Hi,
Selecting the 'Filegroups or files' option in the Back Up or Schedule Backup Jobs wizards will create a full filegroup backup.
To take a differential filegroup backup, add WITH DIFFERENTIAL to ...
Hi,
Thanks for your post. This is a known issue with SQL Backup 7.0 and we expect to fix it in 7.1. In the meantime it should not affect your backup and restore operations. Apologies for the confusion.
Thanks,
Marianne / comments
Hi,
Thanks for your post. This is a known issue with SQL Backup 7.0 and we expect to fix it in 7.1. In the meantime it should not affect your backup and restore operations. Apologies for the confus...
Hi,
You can modify a restore job created by SQL Backup by adding additional steps (for example, using SQL Server Management Studio). As long as the RESTORE command remains a separate job step, you can then edit the job using the SQL Backup UI. From the Jobs tab, double-click the job to open the Edit Restore Jobs wizard. You will only be able to edit those commands which are supported by the SQL Backup UI.
Similarly, any existing restore jobs where the RESTORE command is a separate job step should appear in the Jobs tab of the SQL Backup UI. Double-click a job to edit it. Again, you will only be able to edit commands supported by the UI.
Thank you very much for your feedback.
Cheers,
Marianne / comments
Hi,
You can modify a restore job created by SQL Backup by adding additional steps (for example, using SQL Server Management Studio). As long as the RESTORE command remains a separate job step, you ...
Hi,
Yes, you can restore backups created using SQL Backup 4, 5 or 6 with SQL Backup 7.
Thanks,
Marianne / comments
Hi,
Yes, you can restore backups created using SQL Backup 4, 5 or 6 with SQL Backup 7.
Thanks,
Marianne
Hi PDinCA,
I'm really sorry for the confusion. The documentation will be updated with the correct paths shortly.
Thank you for letting us know.
Marianne / comments
Hi PDinCA,
I'm really sorry for the confusion. The documentation will be updated with the correct paths shortly.
Thank you for letting us know.
Marianne
Hi Chris,
VERIFYINTERVAL continues to be supported in SQL Backup 7. This is a mistake in the documentation and the help on the website will be corrected shortly.
Thanks for raising this,
Marianne / comments
Hi Chris,
VERIFYINTERVAL continues to be supported in SQL Backup 7. This is a mistake in the documentation and the help on the website will be corrected shortly.
Thanks for raising this,
Marianne
Hi EdCarden,
Yes, it is possible to set up a scheduled backup job to take a copy-only backup each time the job runs. Just select the option on step 2 of the Schedule Backup Jobs wizard when you create the job. The option is also available in the Back Up wizard for one-off backups.
Thanks,
Marianne / comments
Hi EdCarden,
Yes, it is possible to set up a scheduled backup job to take a copy-only backup each time the job runs. Just select the option on step 2 of the Schedule Backup Jobs wizard when you cre...