Installing/Uninstalling SQL Backup Manager

Microsoft SQL Server™ support

SQL Backup Manager supports the following 32-bit version of Microsoft Windows SQL Server:

• SQL Server 2005
  
• SQL Server 2005 Express
  
• SQL Server 2000 (Service Pack 3a or later is required)
  
• MSDE 2000

Microsoft Windows support

SQL Backup Manager supports the following 32-bit version of Microsoft Windows operating systems:

• Windows XP
  
• Windows 2000
  
• Windows 2003
  

Licensing

You can register any SQL Server instance with SQL Backup Manager , but you must have a license for each server on which you want to use the SQL Backup Manager backup and restore features.

Details of how you register SQL Server instances are provided in Adding SQL Servers.

Installation overview

To fully install and activate SQL Backup Manager on your SQL Servers:

• Install the SQL Backup Manager graphical user interface.
  For details, see Installing the graphical user interface in this topic.
  
• Using the graphical user interface, register the SQL Server instances on which you want to use SQL Backup Manager.
  For details, see Adding SQL Server Instances.
  
• Install or upgrade SQL Backup Manager on the SQL Server instances as necessary. You can use the graphical user interface to do this, or you can run the Setup wizard manually.
  
• When you have installed SQL Backup Manager, if your license has not already been activated on the relevant servers, the instances are displayed in trial mode.
  
• Activate the licenses on the servers as necessary.
  For details, see Activating SQL Backup Manager.

Installing the graphical user interface

Install the SQL Backup Manager graphical user interface on the computer from which you want to run the backups, using the SQL Backup Manager setup program SQLBackupSetup.exe.

You can install the server components for SQL Backup Manager on the local SQL Server instance at the same time.

To install or upgrade SQL Backup Manager on a SQL Server instance using the GUI

• Start the graphical user interface.
• If it is not already registered, register the SQL Server instance with which you want to use SQL Backup Manager.

The SQL Server instance is displayed in the Registered SQL Servers pane. If one of the following icons is displayed to the right of the name of the SQL Server instance, you can install or upgrade the server components on the SQL Server:

SQL Backup Manger is installed and activated on this SQL Server, but the version of server components is not up-to-date compared with your version of the graphical user interface. (You can continue to use SQL Backup Manager with this SQL Server instance without updating.)

Note that this icon does not show you when new versions of SQL Backup Manager become available for download; you can use Check for Updates for this.

You have not installed the SQL Backup Manager server components on the SQL Server. You must install the server components to use SQL Backup Manager with this SQL Server instance.

• Right-click the SQL Server instance, and click Install or Upgrade Server Components.
  If you are installing SQL Backup Manager for the first time on this server, the Setup wizard guides you through the installation process.
• Ensure that no other SQL Backup Manager processes are currently running on the SQL Server instance, and click Finish to start the installation.
  The Install or Upgrade Server Components dialog box is displayed, and progress of the installation process is shown.
• When the installation has completed, click Close.
  
  

Installing or upgrading SQL Backup Manager on a SQL Server instance manually

You may wish to install SQL Backup Manager on your SQL Server instances manually if your SQL Server security does not allow you to install remotely, or if you want to choose the location of the SQL Backup Manager files.

To install these files manually:

• Copy backupserver_setup.exe from your SQL Backup Manager installation folder to the SQL Server on which you want to install the components.
  By default, the installation folder is C:\Program Files\DMT Software\SQL Backup Manager
  
• Run backupserver_setup.exe from the SQL Server. The Setup wizard guides you through the installation process. You can specify: the instance on which you want to install the server components
  
  • the startup user for the SQL Backup Manager Service application
    
  • the authentication method to be used for the SQL Server
    
  • the folder in which you want to install the files
• Use the SQL Backup Manager GUI to activate SQL Backup Manager Service on the SQL Server instances as required.

Uninstalling SQL Backup Manager Manager

SQL Backup Manager creates separate entries for the SQL Backup Manager graphical user interface, and the SQL Backup Manager server components in your Add or Remove Programs control panel. You can add or remove each of these programs in the usual way.

If you remove the server components, the extended stored procedures, the SQL Backup Manager Service, and the SQL Backup Manager binaries are all removed from the SQL Server.

You will be prompted to confirm whether you want to remove the SQL Backup Manager file that contains the history of your backup and restore activity. If you intend to reinstall SQL Backup Manager, you are recommended to click No to retain the file for future reference; click Yes to remove this file only if you are removing SQL Backup Manager from your computer permanently.