Installation and setup

Perform the following steps to install and set up the sybfilter driver.

On Windows Vista, you must be logged in as an Administrator to install, set up, and run the sybfilter driver.

In Windows Explorer, navigate to the sybfilter driver installation directory. On Windows, this directory is located at %SYBASE%\MA-15_1\system\<platform>.

Here, <platform> is winx86, winx64, or winvistax64.
Right-click the sybfilter.inf file to install the sybfilter driver.

There can be only one installation of the sybfilter driver on a Windows machine. Once the driver is installed, it works for all Mirror Replication Agent for Microsoft SQL Server instances running on the same machine.
Under any directory, create a configuration file to store all log file paths for primary databases. The configuration file must have a .cfg suffix.

For example, under the directory %SYBASE%\MA-15_1\system\<platform>, create a file named LogPath.cfg.
Add a system environment variable named RACFGFilePath, and set its value to the path of the configuration file.
1. From the Control Panel, open System | Advanced | Environment Variables.
2. Click New to add a new system variable.
3. Name the variable RACFGFilePath, and set its value to the location of the your configuration file.
In Windows Explorer, navigate to %SYBASE%\MA-15_1\bin, and double-click the sybfiltermgr.exe file to start the sybfilter driver management console.
To start the sybfilter driver, enter start at the management console.
Add the log file path to the sybfilter driver with the user manager or by modifying the configuration file:

If the log file is a raw partition drive, there is no need add the raw partition path to the configuration file. The sybfilter driver will automatically—without checking the configuration file—change the read permission for the raw partition to nonexclusive so that the log file can be read.
- User manager – Use the add command in the management console:
```
add serverName dbName logFilePath
```
  For example, to add the log file named pdb2_log.ldf at D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ to the dbName database on the serverName data server, use the following:
```
add myseverName dbName D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\pdb2_log.ldf
```
  If you add the log file path with the user manager, the user manager refreshes all log paths to the sybfilter driver automatically after adding the log path into the configuration file.
- Configuration file – To add the log file path directly to the configuration file, open and manually edit the configuration file. The following is an example of log file path entries:
```
[myserver, pdb1]
log_file_path=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\pdb11_log.ldf
log_file_path=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\pdb12_log.ldf
[myserver, pdb2]
log_file_path=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\pdb2_log.ldf
```
  Once you have added the log file paths to the configuration file, you must use the refresh command in the management console.
If you added a log file for your primary database before adding the log file path to the sybfilter driver, you must restart Microsoft SQL Server to make the log file readable.
At the management console, enter check to verify that log files are readable.

If some log files are unreadable, make sure the files have been created and that Microsoft SQL Server has been restarted, if necessary.