Properties of SQL Server: <instance name> (General)

Updated

Use this dialog box to manage the SQL Server Instance properties.

Client name

Displays the name of the client computer on which this instance is found.

Agent

Displays the name of the agent to which this instance belongs.

Instance Name

Displays the name of the selected Instance.

Version

Displays the SQL version.

Server Type

Displays the server type according to the instance selected to be added.

VDI Timeout

Use the space to type the VDI Timeout value in seconds.

When restoring a SQL database, the VDI timeout represents the time the system must wait for the SQL Server to become ready to accept data into the database. If the database you are attempting to restore is particularly large, it may become necessary to increase this time-out value.

Use VSS

Available for SQL Server clients running on Windows Server.

When selected, traditional full backups for all databases within the instance will be switched to VSS full backups.

When cleared, all full backups for all databases within the instance will use the traditional backup methods.

Description

Use this field to enter a description about the entity. This description can include information about the entity's content, cautionary notes, etc.

Save As Script

Click to open the Save As Script dialog, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using qoperation execute command.

When you save an operation as a script, each option in the dialog will have a corresponding XML parameter in the script file. When executing the script, you can modify the value for any of these XML parameters.

Was this page helpful?