Creating a test database for troubleshooting

Issue

Creating a test database for troubleshooting

Product Line

Andover Continuum

Environment

Continuum test database

Cause

There are times when troubleshooting an issue when creating a test database is useful.

Resolution

Open up Database Initialization

  1. Select Server if you have a LAN install with a Full SQL license or Stand Alone if you are using MSDE or SQL Express
  2. Click on the Create New database radio button (bottom right) which opens up the needed fields
  3. Change the Database name from Continuumdb (default) to Testdb
  4. Under Device Information, Change Database from ContinuumDev to TestDev
  5. Under Device Information, Change Database from ContinuumLog to TestLog
  6. Ensure the path is correct for DB File location
  7. Enter in the sa password
  8. Click Continue (This creates 2 files TestDev.mdb and TestLog.ldb in the DB File folder)


Go to Database Initialization again

  1. Select Workstation
  2. Leave the info on the workstation tab exactly as they are
  3. Click on the Database tab
  4. Change the Database Name from Continuumdb to Testdb
  5. Click Ok (This will resolve the workstation to the new test db)


Start Continuum and perform the test and see if the issue still happens on this clean db.

  1. Once the test is completed, delete the Testdb database from Enterprise Manager or use osql
  2. Go to Database Initialization again
  3. Select Workstation
  4. Leave the info on the workstation tab exactly as they are
  5. Click on the Database tab
  6. Change the Database Name from Testdb to Continuumdb
  7. Click Ok (This will resolve the workstation back to the Continuumdb)