Manually Installing the BigTime Database

If the BigTime server fails to restore your initial database, then BigTime Setup creates a file called [InstallDir]\DB\BTSetup.SQL which can be used to run the restore manually. After verifying that the DB share is visible from your SQL system, follow the steps below:

1. Transfer all of the files in c:\Program Files\BigTime\DB\ directory to a local drive on your SQL Server.
2. Login as an administrative user and open up the SQL Query Analyzer.
3. Open and run BTSetup.SQL (note that this file attempts to restore a BAK file in the first line. You may need to edit the location of the BAK file or the location of the target data files so that they are placed in the right spot within your SQL Server).
4. Run the Ind_Data.SQL (from the same location). This will load data from your selected industry skin into the new database.

Once these two files have been created, you can remove any of the \DB\ files you copied from the BigTime server. Your database server no longer needs access to them.