EMS logo

Products Navigation

SQL Backup for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for SQL Server

Product FAQs

Table of contents

Q:
What versions of SQL Server does SQL Backup support?
A:
SQL Backup works with all SQL Server versions (except Compact Edition) from SQL Server 2000 up to SQL Server 2014.
Q:
Must SQL Backup be installed on each server which I want to work with?
A:
Yes, SQL Backup server components must be installed on each instance of SQL Server.
Q:
I have 5 SQL Servers, 2 of which have two SQL Server instances running, how many licenses for SQL Backup do I need to purchase?
A:
Totally you have 7 instances of SQL Server, it means that you need to purchase 7 licenses for SQL Backup.
Q:
How does SQL Backup reduce backup size?
A:
This is achieved by compressing data received from the server during the backup process.
Q:
Does the backup compression depend on SQL Server version or edition?
A:
SQL Backup uses its own data compression function, which does not depend on a version and edition of SQL Server.
Q:
How much is backup file size reduced and what does it depend on?
A:
It depends on data stored in the database and on a selected in SQL Backup compression level. In case of text/numeric data when using compression, backup file size can be up to 80% less in comparison when compression is disabled. If a database mostly stores difficult to compress binary data, such as raster images in JPEG, the compression function cannot significantly reduce the backup file size.
Q:
Can I restore a backup file of SQL Backup on SQL Server with no SQL Backup components installed?
A:
No, you cannot. However, you can use the ConvertUtil.exe command line utility which does not need to be installed and registered to convert backup files of SQL Backup format to the standard SQL Server format. After being converted backup can be restored using standard SQL Server tools.
Q:
What are the reasons for reduction of time required for backup and recovery?
A:
The compression level selection allows you to find a compromise between the backup speed and file size. At the same time the backup time execution can be reduced up to 80% compared with a native tool due to lower load on the disk subsystem.
Q:
Does SQL Backup use undocumented features of SQL Server?
A:
SQL Backup uses only documented features of SQL Server, that guarantee its correct working on all available versions of SQL Server, as well as on future version releases.
Q:
Can SQL Backup perform a standard backup, suitable for recovery on SQL Server, without using SQL Backup?
A:
Yes, SQL Backup can do it. To do this you need to select SQL Server as a backup type in the Backup Wizard.
Q:
Does SQL Backup support log shipping?
A:
SQL Backup preforms log shipping using its compression and encryption features, which make this process faster and more secure.
Q:
I have servers in different time-zones. At what time-zone will tasks be launched?
A:
When creating a policy, you can select whether a task on servers with different time-zones is launched at servers standard time or simultaneously against the console time. This option is called “Task Scheduling in different time zones” at Step 1 of the Policy Wizard.
Q:
What is the advantage of using the Policy Engine of SQL Backup compared to standard maintenance plans of SQL Server?
A:
SQL Backup Policy Engine provides the following features:
  • Using SQL Backup backup functionality
  • Ability to deploy and monitor policies on multiple servers of different versions simultaneously
  • Easy-to-use policy monitoring mechanism
  • Ability to use templates
Q:
Can different types of maintenance tasks go in the same policy?
A:
A policy can contain both multiple tasks of different types and multiple tasks of the same type.
Q:
Can policy tasks have their own execution schedules?
A:
Yes, each task can have one or more schedules.
Q:
Can SQL Backup perform a single maintenance task without creating policies?
A:
Yes, you can perform a maintenance task using the “Quick Maintenance Actions” context menu item of the Server tree.
Q:
Can I execute multiple policies simultaneously on one server?
A:
Several policies can be deployed to a single server, their runtime can be the same and the execution time can intersect. However, 2 tasks of backup/recovery/log shipping can not be executed simultaneously on a single SQL Server instance.
Q:
I have setup SQL Server maintenance plans. Can I use them in SQL Backup?
A:
You can convert SQL Server maintenance plans into SQL Backup policies using the Maintenance Plan Conversion Wizard (“Maintenance Policies | Convert from Maintenance Plan” context menu of the Server tree).
Q:
How does SQL Backup notify about the policy execution failure?
A:
SQL Backup has the e-mail notification mechanism informing of the policy execution results. Also SQL Backup Console displays statuses and results of policies while connecting to a server.
Q:
Can I monitor/manage my set of servers using two (three) different (installed on different computers) consoles?
A:
Yes, you can. However, your SQL Backup Console configuration must be accessible from all your computers.
The configuration can be stored both in a file and in a database on any SQL Server. In this case it is recommended to store the configuration on SQL Server. To change the configuration storage location, call “Options | Save Configuration”, specify a new location and enable the “Switch to saved configuration” option to use the new location. In SQL Backup Console, installed on other computers, you should switch to the new location using the “Options | Switch Configuration” dialogue.
Q:
Whether the servers, SQL Backup works with, must be located within one local network?
A:
Servers can be located anywhere. If you are able to connect to your servers using SQL Server Management Studio, SQL Backup is able to work with them too.
Q:
Do I need to open any additional ports or to enable protocols for working with SQL Backup?
A:
It is neither necessary to open additional ports nor enable protocols beyond those that are already used by your SQL Server Management Studio.
Q:
Can I install SQL Backup server components remotely?
A:
Yes, you can install SQL Backup server components remotely from SQL Backup Console. In the Server tree select SQL Server, on which you want to install the components and click “Install Server-Side SQL Backup Components” in the context menu. Then follow the instructions of the wizard.
For remote installation the following conditions must be met:
  • Installing via SQL Server: You must have an account with SQL Server System Administrator Privileges, such as sa. SQL Server service must be run under an account with Windows Local Administrator Privileges, such as LocalSystem.
  • Installing via NETBIOS: You must have Windows System Administrator Privileges on the remote computer. You must have an account with SQL Server System Administrator Privileges, such as sa.
Q:
I’ve failed to install server components remotely using SQL Backup Console due to insufficient privileges or installation errors. Can I run the Installation Wizard on the server machine to install server components?
A:
Yes, you can use the special installation mode of SQL Backup.
  1. Copy the installation package (SQLBackupSetup-1.x.x.xxxx.msi) to the server machine.
  2. Run the following command as Administrator: SQLBackupSetup-1.x.x.xxxx.msi -var:"ServerInstall=1"
  3. Follow the steps of the Installation Wizard. It will automatically find all local server instances to install server components.
Q:
What kind of account should be used for running SQL Backup service?
A:
To run SQL Backup you can use any account with the following privileges:
  • Access to SQL Server with Server Administrator Privileges.
  • Write access to a directory which is used for creating backups.
  • Ability of authorization on another computer on a network for read/record access to a general directory during log shipping process.
НFor example, a system domain user with all the mentioned above privileges can be used. If log shipping process is not planned, Local System embedded account can be used as a system user account.
Q:
Policy execution failed with the error: “The task cannot be completed. The owner (NT AUTHORITY\SYSTEM) of SqlBackup_XXXXXXXX_Task does not have access to server”. Why does it happen?
A:
This error occurs if SQL Server Agent receives wrong information about the privilege set of user NT AUTHORITY\SYSTEM, that is the owner of the executing task. The problem can be solved in one of the following ways:
  • Change SQL Backup service account to any other one that has all the task launch privileges on the server. Recreate a policy.
  • Change the owner of SqlBackup_XXXXXXXX_Task to another user having the permissions to launch tasks.
  • If BUILTIN\Administrators account was removed from the server, restore it using the administrator privileges.
Q:
What is the difference between versions of EMS SQL Backup?
A:
You can view the list of all functional differences in the Feature Matrix.
Q:
May I purchase a license for SQL Backup and later upgrade it to SQL Backup Pro? How much will it cost?
A:
Yes, you can upgrade SQL Backup to SQL Backup Pro at any time by paying the difference in cost between SQL Backup and SQL Backup Pro, that is 325.00 USD
Q:
May I not pay the program maintenance?
A:
The basic price of SQL Backup includes 1 Year Maintenance. Once the Maintenance term expires, you will be able to continue using the software without any limitations; however, you won’t have access to any product updates released after your maintenance expiration date.
Q:
How to transfer a SQL Backup license from one SQL Server instance to another?
A:
In order to transfer a license from one server to another perform the following steps.
  1. In the EMS SQL Backup Administration Console select the server which you wish to move the license from.
  2. In the context menu of the server select the "Deactivate license on ..." item.
  3. Follow the steps of the License Deactivation Wizard.
  4. Select the server on which you want to activate the deactivated license key.
  5. In the context menu of this server select the "Activate license on ..." item.
  6. Follow the steps of the License Activation Wizard.
Q:
I get the "Access is denied" error on trying to install EMS SQL Backup server-side components via Network Folder. How can I fix the problem?
A:
First of all, make sure that the specified account has local Administrator privileges on the machine where the SQL Server service is running. If you still have this problem then one of the solutions is to disable Remote UAC on the target system. It prevents local administrative accounts from accessing ADMIN$ shared folder and running installation process. To disable Remote UAC you need to add an entry in the registry of the target computer:
  • open the registry
  • navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
  • create a DWORD value called LocalAccountTokenFilterPolicy
  • assign this parameter a value of 1
Q:
I have renewed several licenses of SQL Backup. What should I do to make the changes of the maintenance expiration dates applied to the program?
A:
You have to perform the licenses activation in the program once again. The easiest way to do so is:
  1. Run the program and make connections to all your registered servers.
  2. Open “License Manager” by choosing the appropriate “Gear”-menu item.
  3. Click “Reactivate All” below the dialog and wait till the process finishes.
The program should acquire new maintenance expiration dates for all servers.
Q:
How to automate log shipping process in EMS SQL Backup?
A:
The log shipping mechanism is envisaged to increase the failover protection of DB configuration in Microsoft SQL Server. Its essence reduces to the copying of the DB transaction log backup files of a single instance of SQL Server to another instance and subsequent restoring them to the target database without providing shared access. Control of the backup file copying and restoration process while log shipping automation may present a certain difficulty because any “missed” backup file on the target server will lead to impossibility of applying the subsequent files and the neсessity to restore from the full DB backup. More Info
Q:
How to launch the scheduled maintenance of a new server using templates?
A:
EMS SQL Backup has several predefined policy templates that allow adjusting and planning minimal required set of operations for maintaining SQL Server. This article describes the fastest method to setup maintenance of several SQL Server instances using the policy templates in the program. More Info