Restoring the Guard1 Plus SE Configuration database

Published: 2009-05-12

 

Last Updated: 2010-07-26

Applies To

Introduction

In certain circumstances it may be necessary to restore your Guard1 Plus SE Configuration database from a Backup.

 

The Configuration database contains the Guard1 Plus SE licensing information and application User Accounts.

 

The procedure below assumes that G1DBSetup has been run to configure the databases and that the SQL Server name has not changed. 

 

Resolution

WARNING: The procedure below will replace the data in your existing Guard1 Plus SE Configuration database with the data from the Backup database. Verify that you do not need the information (User Accounts, license information) in the current database before continuing. If in doubt, back up the current Configuration database.

 
  1. On a PC where the Guard1 Plus SE Local Client is installed, go to the command prompt and navigate to the Guard1 Plus SE Server share. NOTE: if you are not working on the same PC where the shared folder resides, you will have to map the folder to a local drive, then navigate to that drive at the command prompt.
  2. Type G1Cfg 0 then press Enter. This will display the Current Configuration window which lists your current Data Sources. Leave this window open or print a screenshot of it for reference - you will need the Data Source names later.
  3. Use SQL Enterprise Manager/Management Studio to restore the Backup database to current Configuration database (usually 'Guard1PlusConfig').
  4. Remove the old SQL User (usually 'Guard') from the restored Configuration database.
  5. Add the SQL User (usually 'Guard') to the restored Configuration database and assign this user the db_Owner database role.
  6. On a PC where the Guard1 Plus SE Local Client is installed, go to the command prompt and navigate to the Guard1 Plus SE Server share. NOTE: if you are not working on the same PC where the shared folder resides, you will have to map the folder to a local drive, then navigate to that drive at the command prompt.
  7. Associate the current SQL Login credentials by typing G1Cfg 100;SQL Server;Database;SQL Server Login;SQL Server Password, then pressing Enter.
  8. Click Yes, then OK.
  9. Create your application Supervisor User Account by typing G1Cfg 101;SQL Server Password;Supervisor User;Supervisor Password, then pressing Enter. This will create the Supervisor user with the name and password you supply. The Supervisor account is for Guard1 Plus SE only and does not affect SQL Server. NOTE: The credentials you enter here are case-sensitive.
  10. Click Yes, then OK.
  11. For each Data Source listed in Step 2, type G1Cfg 201;Supervisor User;Supervisor Password;Data Source Name then press Enter.
  12. Click Yes, then OK.
  13. Perform Step 2 again and verify there are no more listed Data Sources in Current Configuration. If there are, repeat Step 11 for each listed Data Source.
  14. For each Data Source shown in Step 2, type G1Cfg 200;Supervisor User;Supervisor Password;Data Source Name;Data Source Type;SQL Server;Database;SQL Server Login;SQL Server Password then press Enter.
  15. Click Yes, then OK.
  16. Type G1Cfg 0 then press Enter. In the Current Configuration window, under Data Sources And Connection Parameters, verify that the name and type of each data source matches the original configuration in Step 2.
  17. For each Data Source listed in Step 16, type G1Cfg 401;Supervisor User;Supervisor Password;Data Source Name then press Enter.
  18. Click Yes, then OK.
  19. After completing Step 17 for all listed Data Sources, close all configuration windows and launch the Guard1 Plus SE Client.

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.