Install the CommServe and Database Engine on Separate Computers

The following procedure describes the steps involved in building such a topology. Note that these procedures require familiarity and understanding of both the Microsoft SQL Server Database Engine and the Windows operating system.

This procedure can be used when you initially install the software, or when you split an existing CommServe.

• CommServe software to be installed on CommServe and SQL Server computers. This installation will automatically install SQL Server software.
• A reliable and fast network connection between these two computers.

If jobs are in progress or other tasks (such as reports or updates) are scheduled, either perform this task at another time or disable all activity or disable all scheduled tasks from the CommCell Console.

1. From the CommCell Browser, right-click the CommServe and then click Properties.
2. Click Activity Control tab.
3. Clear Enable All Job Activity and Enable Scheduler box.
4. Click OK.

1. Click the Start button on the Windows task bar and then click All Programs.
2. Navigate to bull | Calypso and click Service Control Manager.
3. Select All Services in Services.
4. Click Stop to stop all services.

See System Requirements - CommServe for more information on the SQL Server version.

Note that the CommServe Services must be disabled permanently.

1. Click the Start button on the Windows task bar and then click All Programs.
2. Navigate to bull | Calypso and click Service Control Manager.
3. Select All Services in Services.
4. Click Stop to stop all services.

1. Open Microsoft SQL Server Management Studio.
2. Navigate to Server Instance | Database | CommServ.
3. Right-click the CommServ database, select Tasks and then click Backup. The Back Up Database dialog box appears.
4. In the Database, verify the database name.
5. In the Backup type, select Full.
6. In the Backup Component, select Database option.
7. Accept the default backup set name in the Name, or you can enter a different name for the backup set.
8. Specify when the Backup set will expire. By default After is selected with value 0.
9. In the Destination area select Disk option. To select the path, click Add. The selected path will be displayed in the Backup to list.
10. To remove backup destination, select the destination path and click Remove.
11. Click OK.

• Using a physical media
• Using a network drive that is accessible from both the Servers

1. Open Microsoft SQL Server Management Studio.
2. Navigate to Server Instance | Database.
3. Right-click Database, select Restore Database. The Restore Database dialog box appears.
4. On the General page, do the following:
   • In the To Database, select or type the name of a database.
   • To specify the source and location of the backup sets to restore, select From device option.

     Click the Browse button, Backup dialog box appears.

     In the Backup media, select one of the device type.

     Click Add to provide the path of dump file copied in the previous step. Click OK.

5. On the Options page, do the following:
   • In the Restore options, choose any of the options, appropriate for your situation.
   • The Recovery state determines the state of the database after the restore operation.

     Choose Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY) option.

6. Click OK.

Usage:

exec CommServ..executeCSSetupScripts '<path>'

Example

exec CommServ..executeCSSetupScripts 'C:\Program Files\Bull Calypso\Calypso\'

Where

<path> - This is the path of CommServe Installation Directory on SQL Server Computer.

• sCONNECTION
• sDOMAIN
• sINSTANCE

1. From Taskbar, click Start, and then click Run.
2. Type regedit, and then click OK.
3. Navigate to the following key:

   HKEY_LOCAL_MACHINE\SOFTWARE\CommVault Systems\Galaxy\Instance<xxx>\Database

4. Edit the following values:
   • sCONNECTION set it to <SQL Server computer>_commserv
   • sDOMAIN set it to <SQL Server computer>
   • sINSTANCE set it to <SQL Server computer>\BullCalypso

1. Open Control Panel | Administrative Tools | Data Sources (ODBC).
2. Click the System DSN tab.
3. Click <CommServe computer>_commserv and then click Configure.
4. Edit the following values:

   Name -  set it to <SQL Server computer>_commserv

   Server - set it to <SQL Server computer>\BullCalypso

5. Click Next.
6. Choose the With SQL Server authentication using a login ID and password entered by the user option.
7. Select the Connect to SQL Server to obtain default settings for the additional configuration options check box and enter the login and password of the sa user in the SQL Server computer.
8. Click Next twice and then click Finish. (Nothing needs to be changed on these dialog boxes.)
9. Click Test Data Source.

   The result should be TEST COMPLETED SUCCESSFULLY.

   If not make sure SQL server on the SQL Server computer is accessible and the login information given are correct.

10. Click OK.

1. Click the Start button on the Windows task bar and then click All Programs.
2. Navigate to bull | Calypso and click Service Control Manager.
3. Select All Services in Services.
4. Click Start to start all services.

1. From the CommCell Browser, right-click the CommServe and then click Properties.
2. Click Activity Control tab.
3. Select Enable All Job Activity and Enable Scheduler box.
4. Click OK.

1. From the CommCell Browser, right-click the <CommServe>, point to View and then click Schedules.
2. Select and right-click the DR Backup Full schedule in the right pane and click Disable.
3. Click Yes to disable the schedule.

Recommended schedule is a daily full backup.

<sql install path>\Isql.exe -S <SQL ServerName> -U sa -P <sapwd> -q "BACKUP DATABASE [CommServ] TO DISK = 'C:\cs.dmp'"

This should create a dump file c:\cs.dmp.

You can choose the folder in which the .dmp file is created.

Perform the following steps to install updates on SQL Server computer:

1. Services on SQL Server computer are already disabled.
2. Navigate to the <Service Pack> directory.
3. Execute the following command:

   InstallUpdates.exe -doNotUpdateDB -nostartsvc -silent -vm Instance001

Perform the following steps to install updates on CommServe computer:

1. Stop all services on the CommServe computer.
2. Navigate to the <Service Pack> directory.
3. Execute the following command:

   InstallUpdates.exe -nostartsvc -silent -vm Instance001

4. If PendingDBOperation registry key is available at the following location on CommServe computer, then delete the key.

   HKEY_LOCAL_MACHINE\SOFTWARE\CommVault Systems\Galaxy\UpdateFlags\

5. Start all the services on the CommServe computer.

1. Stop all services on the CommServe computer.
2. Navigate to the Base directory.
3. Execute the following command:

   Removeupdates.exe -silent -nostartsvc -vm Instance001 -undo bin

4. If PendingDBOperation registry key is available at the following location on the CommServe computer, then delete the key.

   HKEY_LOCAL_MACHINE\SOFTWARE\CommVault Systems\Galaxy\UpdateFlags\

5. Start all the services on the CommServe computer.

Perform the following steps to install updates on SQL Server computer:

1. Services on SQL Server computer are already disabled.
2. Navigate to the Base directory.
3. Execute the following command:

   Removeupdates.exe -silent -nostartsvc -vm Instance001 -donotupdatedb