Installation Checklist


10-Oct-2002

This checklist creates a database that is adequate for approximately 5-7 million rows in the FileSpec table, allowing for fragmentation over time. The database has a filegroup that can extend to 10 GB and a log that can extend to 2.5 GB.

  1. Check system environment: pagefile.sys
    For Windows NT 4.0 and Windows 2000, Microsoft recommends that the minimum size of the pagefile.sys be the same as the size of the system's installed memory. If necessary, and if there is space, extend the size of pagefile.sys. Reboot later to implement the new size.

  2. Check MSSQL environment
    1. SQL tempdb
      Use SQL Enterprise Manager to check the size of tempdb. Initially, the size should be 500 MB, able to expand to a minimum of 1.5 GB. Use SQL Enterprise Manager to make the following changes:
      • Change space allocated to 500 MB
      • Restrict file growth to a minimum of 1500 MB, depending on available space
      • Check option to grow file automatically: Under "file growth", check megabytes and enter the value 50

    2. SQL installed version.
      In an SQL Query Analyzer window, execute the following command:
      select @@ version

      If you do not have the correct version of SQL server, as described in the File Reporter Configuration and Installation Guide, you must upgrade your SQL server. Service packs are available at the Microsoft web site.

    3. For MSSQLconfiguration parameters, execute the following command in an SQL window, then save and print the results:
      sp_configure

    4. Modify the properties of the model database, which is the template from which the SRMFC database will be created. Execute the following commands in an SQL window:

      exec sp_dboption N'model', N'bulkcopy', N'true'
      go
      exec sp_dboption N'model', N'trunc. log', N'true'
      go
      exec sp_dboption N'model', N'autoshrink', N'false'
      go
      exec sp_dboption N'model', N'auto create statistics', N'true'
      go
      exec sp_dboption N'model', N'auto update statistics', N'false'
      go

  3. Stop and restart the MSSQLServer service, so that changes you made take effect.

  4. Install File Reporter, then ready the newly created SRMFC database for production.

  5. In Control Panel, stop the File Reporter service.

  6. Ready the new SRMFC database for production.
    1. To set default properties for the SRMFC database, execute the following SQL commands:

      exec sp_dboption N'SRMFC', N'bulkcopy', N'true'
      go
      exec sp_dboption N'SRMFC', N'trunc. log', N'true'
      go
      exec sp_dboption N'SRMFC', N'autoshrink', N'false'
      go
      exec sp_dboption N'SRMFC', N'auto create statistics', N'true'
      go
      exec sp_dboption N'SRMFC', N'auto update statistics', N'false'
      go

    2. In Enterprise Manager, click on database SRMFC -> Properties -> Transaction Log
      • Under "space allocated", enter 1000 MB.
      • check "restrict file growth" and enter a size of at least 2500 MB.
      • Under "file growth", check megabytes and enter 50.

    3. To add a filegroup to SRMFC, execute the following SQL commands:

      use master
      go
      alter database SRMFC
      add filegroup SRMFC_tables
      go

    4. This template creates a multi-GB location for the SRMFC database where the FileSpec table will be located. The total space required is a minimum of 10 GB, but realistically should be 12 GB or more.

      Complete the template with the directory location(s) on the server, then execute the following commands in an SQL Query Analyzer window, replacing the G: directory location with the path on available disk(s):

      use master
      go
      alter database SRMFC
      add file
         (
         name = 'SRMFC_tables1',
         filename = 'G:\SRMFC_tables1.ndf',
         size = 500MB,
         MAXSIZE = 5000MB,
         FILEGROWTH = 100MB
         )
      to filegroup SRMFC_tables
      go
      alter database SRMFC
      add file
         (
         name = 'SRMFC_tables2',
         filename = 'G:\SRMFC_tables2.ndf',
         size = 500MB,
         maxsize = 5000MB,
         FILEGROWTH = 100MB
         )
      to filegroup SRMFC_tables
      go

    5. To set the newly created filegroup as the default location where all tables and indexes on SRMFC will be located, execute the following commands in an SQL Query Analyzer window:

      use master
      go
      alter database SRMFC
      modify filegroup SRMFC_tables default
      go

  7. Drop the FileSpec table created by the new installation, and replace it with one that is located on the new filegroup SRMFC_tables. In an SQL query window, run the SQL script named CreateTable_FileSpec.sql.

  8. To drop and recreate one stored procedure, run the SQL scripted named CreateSP_FileSpecIndexes.sql.

  9. To grant privileges on one stored procedure that was created by the CD installation without granting authorization, execute the following commands in an SQL Query Analyzer window:

    grant execute on GetDailySchedule to SRMSvcGroup
    go

  10. Restart the File Reporter service.

 

Miscellaneous SQL commands to replace EnterpriseManager functions, if needed