Storage Resource Manager Enterprise Edition Installation Guide

Storage Resource Manager Enterprise Edition A–5
Database Concepts
If you want to let the installation program create and configure your SRM SQL Server
database, see section “Prepare SQL Server for SRM” in Chapter 2 for the
pre-installation requirements.
When SRM creates and configures an SQL Server database, separate devices are
created for the data and transaction log. These devices are created in the same location
as the master device. Whether you create a database or Setup creates the database,
SRM creates and schedules a maintenance task and configures security. Security is
configured to allow the SRM Service Login Account access to the database.
When you create and configure an SQL Server database for SRM to use, follow the
requirements and guidelines in the following checklist:
• Create the database.
• The new database must be empty. It cannot contain tables, procedures, indexes, or
data. Setup locates the SRMDB data source (instructions for creating this follow);
discovers that it points to an empty database; and creates the necessary tables,
indexes, and data. The databases must be of an adequate size to hold SRM data.
Guidelines for a typical SRM installation are:
— 200 MB for the SRM database (5 MB minimum database size)
— 20 MB for SRM’s database transaction log (required on the master database’s
disk if SRM creates the database)
— Set the SQL Server TEMPDB and its log to automatically expand as needed
— Enough space for online backups dependent on your backup strategy
• On the target SRM Server computer, create a new System DSN for the SQL
Server ODBC driver and name it SRMDB. Configure this new System DSN to
point to the database you just created. Consider the following points:
— Make sure that SRMDB appears in the Name field of the first dialog.
— Verify that the SQL Server name in the Server field of the first dialog is
correct.
— Make sure the Change the default database to field in the third dialog points to
the new database.
— Let the SQL Server driver choose the translation method for the character set
translation option.
— Setup configures all other SRMDB data source settings during the
installation. You do not have to configure these:
With Windows NT/Windows 2000 authentication using the network login