Comments
Sort by recent activity
Hi Chris,
Could you try upgrading again? Version 7.1 should be available now.
Thanks,
Marianne / comments
Hi Chris,
Could you try upgrading again? Version 7.1 should be available now.
Thanks,
Marianne
Hi
Thanks for both your forum posts. Can I check whether you added the sqbsetlogin stored procedure before calling it with blank values?
If the SQL Backup Agent Service was set to use SQL Server authentication when SQL Backup 6 was installed, the stored procedure will not have been added. If the sqbsetlogin stored procedure was used to change to SQL Server authentication later, it may have been dropped after use (as per the instructions in the forum post you refer to and Security Model (http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.0/SBU_SecurityModel). In both these cases you would need to add the stored procedure again before being able to call it.
If this is the case, try adding the stored procedure:
execute master..sp_addextendedproc sqbsetlogin , 'xp_sqlbackup.dll'
Then call the stored procedure with blank values to use Windows authentication:
execute master..sqbsetlogin '', ''
Cheers,
Marianne[/code] / comments
Hi
Thanks for both your forum posts. Can I check whether you added the sqbsetlogin stored procedure before calling it with blank values?
If the SQL Backup Agent Service was set to use SQL Server au...
Hi Chris,
SQL Backup 7.1 will be released soon. We are expecting to release version 7.2 towards the end of Q3.
Cheers,
Marianne / comments
Hi Chris,
SQL Backup 7.1 will be released soon. We are expecting to release version 7.2 towards the end of Q3.
Cheers,
Marianne
Hi Chris
Apologies for not getting back to you sooner. This feature will not be in the next release of SQL Backup (7.1) but we are considering it for version 7.2.
I will add you to the list of users to be notified when this change is made.
Cheers,
Marianne / comments
Hi Chris
Apologies for not getting back to you sooner. This feature will not be in the next release of SQL Backup (7.1) but we are considering it for version 7.2.
I will add you to the list of user...
Hi,
It's the latter case: jobs that are scheduled to run at the same time are highlighted in the timeline as conflicting schedules to warn you of the demand on your server's processors and I/O. This may cause jobs to take longer to run.
Cheers,
Marianne / comments
Hi,
It's the latter case: jobs that are scheduled to run at the same time are highlighted in the timeline as conflicting schedules to warn you of the demand on your server's processors and I/O. Thi...
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...