For best results, use the configuration
wizards to configure Data Protection for SQL Server for
a step-by-step guide of the configuration requirements. However, if
you prefer to do these steps manually, follow these configuration
instructions.
Before you begin
Before you begin, ensure
that the SQL server is running.
Procedure
Perform these steps on the computer where the
SQL Server is installed and running:
- Specify your Data Protection for SQL Server node
name and communication method in the dsm.opt file
located (by default) in the Data Protection for SQL Server installation
directory. More options are also available.
- Using the set command, specify your Data Protection for SQL Server preferences
(language, date format, log file) in the tdpsql.cfg file in the Data Protection for SQL Server installation
directory.
- If you are configuring Data Protection for SQL Server in an
SQL Server 2012 environment, specify the Tivoli® Storage
Manager node
name that is used to back up the AlwaysOn availability databases.
You can specify the AlwaysOn node name by using the alwaysonnode option
in the tdpsql.cfg file. For example:
set alwaysonnode myAlwaysOnNode
All availability databases in an availability group are backed
up under this node name. Any stand-alone databases are backed up under
the standard Data Protection for SQL Server node name.
- For SQL Server 2012: If you want all
databases to be backed up by default under the AlwaysOn node, specify
the usealwaysonnode option in the tdpsql.cfg file.
For example:
usealwaysonnode yes
This option is useful if you are changing your database backups
from the standard Data Protection for SQL Server node
to an AlwaysOn node.
- (VSS only) Specify your VSSPOLICY statement
in your Data Protection for SQL Server configuration
file.
- (VSS only) Configure the Tivoli Storage
Manager backup-archive
client if it is not already configured. If the backup-archive client
is already configured, you can use existing client services. The backup-archive
client Setup Wizard can guide you through the configuration process.
In the backup-archive client GUI menu, select . The node name
for this system is referred to as the Local DSMAGENT Node and
is specified with the localdsmagentnode parameter
in the Data Protection for SQL Server configuration
file (tdpsql.cfg).
For more
information, see Tivoli Storage
Manager for
Windows Backup-Archive Clients Installation and User's Guide and "Proxy
node definitions".
- (VSS only) Install and configure the Tivoli Storage
Manager Client
Acceptor Service (CAD) if it is not already installed and configured.
In the backup-archive client GUI menu, select . Make sure that the CAD service
is running before you proceed to the next step.
- (VSS only) Install and configure the Tivoli Storage
Manager Remote
Client Agent Service (DSMAGENT) if it is not already installed and
configured. In the backup-archive client GUI menu, select . If a DSMAGENT is already installed and configured,
you can use the existing one.
- (VSS only) If you want to manage local persistent VSS snapshots,
which are created for VSS backups to LOCAL, VSS Instant Restores,
and want to run offloaded backups, you must install IBM® Tivoli Storage FlashCopy® Manager.
- (VSS only) Install and configure a VSS provider. Consult
the VSS provider documentation for information about configuration
of that software. There is no installation or configuration that is
required if you are using the default Windows VSS
System Provider.
- (VSS only) Change the SQL Server VSS
Writer from Manual to Automatic and start the service.
- (VSS only) Define storage space to hold VSS backups that
is on local shadow volumes.
Define enough space to hold all copies of the VSS backups as designated
by your policies. Provisioning storage space to manage VSS snapshots
is dependent on the VSS provider that you use. Consult the VSS Provider
documentation for more details.