User profile for Marianne

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

0 votes

Hi Andy, Many thanks for your message and feedback on FULLIFREQUIRED. We are hoping to fixing this issue in a future version of SQL Backup. Unfortunately, I can't confirm when that will be as yet. The reference for this is SB-5139. Thanks, Marianne / comments

Hi Andy, Many thanks for your message and feedback on FULLIFREQUIRED. We are hoping to fixing this issue in a future version of SQL Backup. Unfortunately, I can't confirm when that will be as yet. ...

0 votes

Hi Many thanks for your feedback. The 'Compressed Size' column in the Backup Properties dialog shows the size of the backup file (whether it was compressed or uncompressed). The column label will be changed in the next version to reflect this. Cheers, Marianne / comments

Hi Many thanks for your feedback. The 'Compressed Size' column in the Backup Properties dialog shows the size of the backup file (whether it was compressed or uncompressed). The column label will b...

0 votes

Hi, The File Size column refers to the size of the database files (.mdf, .ndf and .ldf) on disk. We will change the column labels in the next version to make this clearer. Cheers, Marianne / comments

Hi, The File Size column refers to the size of the database files (.mdf, .ndf and .ldf) on disk. We will change the column labels in the next version to make this clearer. Cheers, Marianne

0 votes

Hi Stephen, Many thanks for the feedback - I'll add the feature request to our list. Cheers, Marianne / comments

Hi Stephen, Many thanks for the feedback - I'll add the feature request to our list. Cheers, Marianne

0 votes

Hi, Many thanks for your post. I need a bit more information from you. Can you confirm that you were running SQBServerSetup.exe manually to install the server components (it sounds like it, but I just want to double check)? If so, were you following the instructions on installing the server components on clusters (http://www.red-gate.com/SupportCenter/Content/SQL_Backup/help/7.1/SBU_InstallingonaSQLServerCluster) and did you disable the SQL Backup resource in Cluster Administrator before upgrading? If not, could you try following those steps? Cheers, Marianne / comments

Hi, Many thanks for your post. I need a bit more information from you. Can you confirm that you were running SQBServerSetup.exe manually to install the server components (it sounds like it, but I j...

0 votes

Hi It is not possible to back up specific tables. However, you can select Filegroups or files on step 2 of the backup wizards, then select the particular filegroups or files of a database that you want to back up. Cheers, Marianne / comments

Hi It is not possible to back up specific tables. However, you can select Filegroups or files on step 2 of the backup wizards, then select the particular filegroups or files of a database that you ...

0 votes

Hi, You can restore a backup from one server to an existing or new database on a different server using the Restore wizard (in v6.5 and v7+) or the Schedule Restore Jobs wizard (v7+ only). To restore a backup to a different server using the Restore wizard: - On step 1 select Browse for backups to restore from the drop-down list. - Then specify the server you want to restore the backup to. - Click Add files to open the File Browser and browse for backup files to restore. Backups stored on the server you are restoring to are displayed. You can view backups stored on another server by selecting the server from the drop-down list, or clicking Add server to add another server. - Proceed through the rest of the wizard as normal. Further information, including how to restore from a different server using the Schedule Restore Jobs wizard, is available here: http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.1/SBU_BackUpRestoreNetworkShare Finally, if you would like to evaluate SQL Backup 7, you can download a free trial from our website here: http://www.red-gate.com/products/dba/sql-backup/ I hope that helps. Thanks, Marianne / comments

Hi, You can restore a backup from one server to an existing or new database on a different server using the Restore wizard (in v6.5 and v7+) or the Schedule Restore Jobs wizard (v7+ only). To resto...

0 votes

Hi, Thanks for your post. When using the extended stored procedure, the parameters must be surrounded by one set of single quotes, so any variables inside the command must be surrounded by two sets of single quotes (or square brackets). If your database name includes spaces, you should surround it with square brackets, rather than two pairs of single quotes. Your command should look like this (replacing variables and WITH options as required): execute master..sqlbackup '-sql "BACKUP DATABASE [database name] TO DISK = ''C:\Backups\<AUTO>.sqb'' WITH CHECKSUM, THREADCOUNT = 3" ' (The disk location is surrounded by two sets of single quotes, whereas the BACKUP command is surrounded by one set of double quotes. The entire parameter is surrounded by one set of single quotes.) There is more information about using the extended stored procedure here: http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.1/SBU_UsingStoredProc and examples of SQL Backup syntax here: http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.1/SBU_Toolkit_syntax_egs If this doesn't help, can you post the exact command you are using? Thanks, Marianne / comments

Hi, Thanks for your post. When using the extended stored procedure, the parameters must be surrounded by one set of single quotes, so any variables inside the command must be surrounded by two sets...

0 votes

Hi I'm not entirely clear on what you want to achieve. It sounds like you're running the UI on your desktop machine and the server components installed on it are no longer licensed, but you have installed server components on other machines and these have valid licenses. Is that right? You can use the UI where you want - it is not licensed. You can add SQL Servers to the Registered SQL Servers pane on the left of the timeline so that you can manage your SQL Servers from your desktop machine (from the File menu select Add SQL Server. See http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.1/SBU_RegisterServers for more details). You need to install the SQL Backup server components on each server and activate the server components with a license key. If the license has expired for a server, you will not be able to perform backup and restore operations on that server (an icon is displayed to indicate this). But the fact that the license has expired on the local server does not mean that you cannot connect to other SQL Servers from the UI and use SQL Backup to perform backup and restore operations on them. As PDinCA described, if you upgrade the UI to 7.1 (either by using Check for Updates, or by downloading from the website), a cog icon will appear next to each server that you have added to the Registered SQL Servers pane on the left of the timeline to indicate that the version of the server components does not match the UI. If you click the cog icon (or select a Server then select Install or upgrade server components from the Actions menu), you can upgrade the SQL Backup server components on that server. You do not have to upgrade the server components - the UI is backwards compatible, but some features may not be available (these will be indicated in the relevant wizards). See http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.1/SBU_InstallingonaSQLServerinstance There is no need to pull folders to your desktop machine. Alternatively, you can upgrade the server components manually by running SQBServerSetup.exe on the relevant servers (SQBServerSetup.exe is copied to the installation folder when you install/upgrade the UI. By default this is %Program Files%\Red Gate\SQL Backup 7 or %Program Files (x86)%\Red Gate\SQL Backup 7.) This is recommended for clustered installations. If you want to upgrade the server components without upgrading the UI, you can still add the servers to the UI and manage them from there. However, note that this is not recommended as we do not support forward-compatibility of the UI. I hope that helps. Cheers, Marianne / comments

Hi I'm not entirely clear on what you want to achieve. It sounds like you're running the UI on your desktop machine and the server components installed on it are no longer licensed, but you have in...

0 votes

How can we help you today?

Marianne

Comments