Tune-up for SQL Database

Introduction (Please Read)
This document will help you perform a tune-up of your SQL database in addition to the Realhound tune-up. This SQL tune-up should be completed on a weekly basis to keep your database running at full speed.

Step 1.Log out of your Realhound database and ensure that all other users are logged out of the database as well. It is imperitive that all users are logged out of the database before performing this tune-up. Failure to do so will cause irreversable damage to your database.

Step 2. Go to the Realhound program folder on your machine housing the SQL database. The program folder will be located by default in C:/rhserver/realhnd. Inside this folder you will see the file ‘reindex.sql’. Double-click on this file to run the SQL tune-up.

The SQL reindex performs the following functions…

1. Performs its own reindex

2. Rebuilds the temporary fields within the database
(many things are denormalized in the database for speed,
such as related contact names on the task list, these are refreshed)

3. Fixes any invalid records in the database
(these can occur if a program loses network connection
during a read/write process)

4. Verifies all of the primary keys in each table

5. Deletes any orphan records that may not have been
deleted through normal processes if SQL Server had them locked

6. Verifies the structure of the database against a current baseline
(if we add fields, this is how they get added to the database)

SQL Database Grows Extremely Large

Introduction (Please Read): This document will walk you through the steps needed to turn off the transaction logs in SQL. These transaction logs can cause your SQL database to grow extremely large and take up valuable hard drive space. Running SQL in Full Recovery Mode allows for complete back-ups to be taken of a database during changes, although the transaction logs can become large enough to take up an entire hard drive if left on long enough. To Decrease the SQL database size and recover hard drive space. Step 1 – Set SQL to run in Simple Recovery Mode Step 2 – At the Realhound login screen, run a speed-up of the database to decrease database size dramatically.

SQL Remote Access Setup

Introduction (Please Read):
This document will walk you through the steps needed to access the program while in separate offices. Please note – A better plan is to install RH on the user’s laptop and use Live to connect to their database.

Step 1 – Open regedit from the registry
hkey_local_user\software\realhound.com\realhound key.

Step 2 – Look for the values are:


The best idea would be to have a .reg script saved from regedit with the keys you want, then this is run before logging into RH.

You will likely have speed issues though as you are no longer on the local LAN.

How to Sync Live SQL Server Database When Realhound is Not Running

How to Sync Live SQL Server Database When Realhound is Not Running

Introduction (Please Read): This document will provide you with the steps needed to sync a Live database when Realhound is not running (i.e. on a server). As with the rest of the SQL server setup process, this should only be attempted by someone with a strong IT background and SQL experience. Steps: /ss: /sd:realhound /sp:realhound /su:realhound /u:administrator /p:realhound /t:c:\rhtemp /h:365 /x Sync
Error Installing SQL Server Express 2005

Error Installing SQL Server Express 2005

Introduction (Please Read): This document will provide you with the steps necessary to completing the installation of SQL Server Express 2005. If the MSXML or any of the other components don’t install properly, then it is likely that you have a previous version of the component installed. SQL Install Steps: 1. Go to http://support.microsoft.com/kb/290301 and download the Windows Installer Cleanup Utility package. 2. Once the package downloads, double-click on it to install it. 3. Once the installation finishes, run the program (go to your Start Menu –> All Programs and select the utility). 4. In the window that opens, scroll through the list and identify any MSXML or SQL programs. For each one, select it in the list and click the Remove button. NOTE: Be cautious when removing any programs with this tool as you will be permanently removing programs from your computer. Do not attempt unless you understand what you are removing. 5. Once this has been done for each of the previously existing programs, close the Windows Install Cleanup Utility and go through the installation again.
8501: Unable to Connect

8501: Unable to Connect

Introduction (Please Read): This document will provide you with a suggestion to resolving an error stating “8501: Unable to Connect…” when setting up a SQL Server installation of the program. 8501 Error Explanation: This error means that there is something interfering with the connection between the computer attempting to access the SQL database and the server and database itself. This can be caused by any of a number of different reasons and the setup itself should be handled by someone with a strong IT background. One great place to check and verify the appropriate setup is with the Configuration Tools of SQL Server Management Studio Express. There you will need to ensure that you have it set to Allow External Connections into the Surface Area Configurations.