Instances - Microsoft SQL Server

Overview

In the CommCell Console, you can add and configure an instance for each available SQL Server. Each configured SQL Server instance automatically spawns a default Database subclient that can include three SQL Server system databases as well as user-defined databases. See Subclients - SQL Server for an overview. Note that the system databases are just like user-defined databases in the system.

See Instances for an overview of Instances. Given below is a list of what you need to provide before creating a SQL Server 2000 or 2005 instance.

Local administrator with SQL sysadmin role
Account password
Default database storage policy
Default log storage policy

Use the procedures within Add an SQL Server Instance for the following instance scenarios:

When you are adding instances in any cases not covered by the previous two bullet items.

Configurable Properties

Once installed, the agent is configured and is therefore able to manage the data or volumes on the client computer. However, you can change certain aspects of the instance configuration to manage the data in the manner that best suits your needs.

You can view or change the instance configuration from the Instance Properties dialog box. The following information can be configured.

Setting the VDI Time-out Value for Large SQL Database Restores

For Microsoft SQL Server iDataAgents, you may have to administer this value during the restore of a SQL database that has been dropped or does not exist on the SQL server. This is especially true for large databases. See Set the VDI Timeout Value for Large SQL Database Restores for an overview.

Using VSS

Available for SQL Server clients running on Windows Server. When left cleared, all full backups for all databases within the instance will use the traditional backup methods. When selected, traditional full backups for all databases within the instance will be switched to VSS full backups. When cleared after having been selected, subsequent backups will run as their designated type. See VSS for SQL Server iDataAgents for more information.

User Accounts

Use the Accounts tab to identify the account that the system uses to access the associated instance.

See the Microsoft SQL Server iDataAgent section in User Accounts and Passwords for more information.

The following pertains to SQL Server and SQL Server 2005:

One or more of the agents of this type use one or more accounts that are configured from a non-Properties dialog box. See the appropriate section for your agent(s) in User Accounts and Passwords for more information.