Configure Instance

Configuring SQL Server instance information

Before Backup Agent do backup or restoration job, it should know the instance information .To add an instance to be backed up or restored select a connected Backup Agent and select the "Instances" tree node in "Backup Agent Manager" window , then click the "New Instance" button , following setting window pops up:

Server Instance : The SQL Server database instance to be backed up.
SQL Server Type : The SQL Server edition of selected instance .
Name/ Alias : An alias for the SQL Server database instance.
Account Information : Microsoft SQL Server provides two types of user authentication , one based on applying the user's Windows login identification , one that uses a separate user list specific to Microsoft SQL Server . please select a valid account information and the click "Test" button , if it show OK message , then click "OK" button to save new add instance information.

Select a Backup/Restore interface : After you select a correct SQL Server edition for instance , it will select an interface to do backup and restore job automatically. For 7.0 or MSDE , pipe is use in the job . SQL 2000 supports both Pipe and Virtual Device interface. If your server is SQL Server 2000 or later , please select the VDI as backup/restore interface.

Virtual Backup Device Interface Configuration : If the instance use VDI as backup interface , these options for advanced user.

VDI Timeout : The time that a VDI object waits. Increase this time if the database to be restored contains very large data files. The value 0 causes an infinite time-out.

Number of virtual device : The number of threads used for retrieving data from Microsoft SQL Server. This parameter determines the number of CPUs that are used to perform backups. Setting this value to match the number of CPUs in the database server will generally result in the fastest backup performance.

Number of VDI buffers: The total number of buffers (of maximum transfer size) that are used to back up and restore.

Maximum VDI transfer size: The maximum input or output request issued by Microsoft SQL Server to the device. This is the data portion of the buffer. This parameter value must be a multiple of 64 KB. The range is from 64 KB to 4 MB.

VDI block size: All data transfers are in integral multiples of this value. Values must be a power of 2 between 512 bytes and 64 KB inclusive.

Note: If you have more than one instance of Microsoft SQL Server installed and want to back them up, you must add them one by one for every instance.