Installing and Setting Up the sybfilter Driver

Install and set up the sybfilter driver.

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

   where <platform> is one of:

   • winx86–if your operating system is 32-bit version of Windows Server 2003, Windows Server 2008, Windows Vista, or Windows XP.

   • winx64–if your operating system is 64-bit version of Windows Server 2003 or Windows XP.

   • winvistax64–if your operating system is 64-bit version of Windows Server 2008 or Windows Vista.

2. Right-click sybfilter.inf to install the sybfilter driver.
   Note: There can be only one sybfilter driver on a Windows machine. Once the driver is installed, it works for all Replication Agent for Microsoft SQL Server instances running on the same machine. The sybfilter driver must be installed on the same machine as the primary Microsoft SQL Server.
3. In 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%\RAX-15_5\system\<platform>, create a file named LogPath.cfg.

4. 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.
5. In Windows Explorer, navigate to %SYBASE%\RAX-15_5\bin, and double-click sybfiltermgr.exe to start the sybfilter driver management console.
6. To start the sybfilter driver, enter start at the management console.
7. Add the log file path to the sybfilter driver with the user manager or by modifying the configuration file. Use directory and drive names that are recognizable to the primary Microsoft SQL Server.

   • User manager – use the add command in the management console. The syntax for this command is:

     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:

     add myseverName dbName D:\Program 

     Files\Microsoft SQL 

     Server\MSSQL.1\MSSQL\Data\pdb2_log.ldf

     Note: If you add the log file path with the user manager, the user manager automatically refreshes all log paths to the sybfilter driver 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. This 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

     Note: Once you have added the log file paths to the configuration file, use the refresh command in the management console.
8. If you added a log file for your primary database before adding the log file path to the sybfilter driver, restart Microsoft SQL Server to make the log file readable.
9. 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.