How to create a Guard1 Plus SE Backup from a standalone Guard1 Plus database

Published: May 22, 2007

 

Last Updated: 2010-07-26

 

Applies To

 

Introduction

It is possible to open Guard1 Plus version 2.x and 3.x databases as Backup databases in Guard1 Plus SE. If you are doing this after you have already converted the 2.x/3.x master database to Guard1 Plus SE format you must follow this procedure. You will temporarily assign your master database as a Backup while you use the G1 Conversion Wizard to convert the Guard1 Plus version 2.x/3.x Backup to a Guard1 Plus SE Backup. After this conversion is completed, you will restore your Guard1 Plus SE master database and change the newly converted database to a Backup.

 

For further information on how to run the Guard1 Plus SE Conversion Wizard or the Guard1 Plus SE Configuration Utility, refer to the Guard1 Plus SE Administrator's Manual that is included on the Guard1 Plus SE CD.

 

More Information

Create a Guard1 Plus SE Backup file by following these steps.

 

  1. In SQL Enterprise Manager/Management Studio, create a new database named "BackupGuard1Plus". This new database will contain the data from the older Guard1 Plus version 2.x/3.x database.
  2. Add the Guard1 Plus SE SQL User (usually 'Guard') to the new database and assign this user the db_Owner database role.
  3. Using Enterprise Manager/Management Studio, open the table DataSource in the Guard1 Plus SE Configuration database (usually 'Guard1PlusConfig').
    1. Change the Type record for the current Master database (usually 'Guard1Plus') from 1 (Master) to 3 (Backup). NOTE: this is a temporary setting and will be changed back at the end of the procedure.
  4. 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.
  5. Type G1Cfg 200;Supervisor User;Supervisor Password;Data Source Name;1;SQL Server;Database;SQL Server Login;SQL Server Password then press Enter.
    • Where:
      • Supervisor User = an application User that has Supervisor rights
      • Supervisor Password = the password for the above Supervisor user
      • Data Source Name = the name that you want to appear within Guard1 Plus SE when selecting the Backup database to view.  Usually the name of the database as it appears in SQL Enterprise Manager/Management Studio.
      • SQL Server = the name of the SQL Server where the new databases reside
      • Database = the name of the new database you created in Step 1
      • SQL Server Login = the SQL Login associated with Guard1 Plus SE
      • SQL Server Password = the password for the above SQL Login
  6. Click Yes, then OK.
  7. Initialize the new database by typing G1Cfg 202;Supervisor User;Supervisor Password;Data Source Name, then pressing Enter.
    • Where:
      • Supervisor User = an application User that has Supervisor rights
      • Supervisor Password = the password for the above Supervisor user
      • Data Source Name = the name of the new database you created in Step 1
  8. Click Yes, then OK.
  9. Using the G1ConversionWizard, import the Guard1 Plus version 2.x or 3.x database file into the new database 'BackupGuard1Plus'.
  10. Using Enterprise Manager/Management Studio, open the table DataSource in the Guard1 Plus SE Configuration database.
    1. Change the Type record for the new database ('BackupGuard1Plus') from 1 (Master) to 3 (Backup).
    2. Change the Type record for the Master database ('Guard1Plus') from 3 (Backup) to 1 (Master).
  11. Open the Guard1 Plus SE Client.
  12. Click File > Open Backup and verify that you can open the Backup database successfully.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.