Restoring the Guard1 Plus SE Application database
Last Updated: 2010-07-26
- Guard1 Plus SE versions: 4.12, 4.20, 4.30, 4.40
The procedure below assumes that G1DBSetup has been run to configure the databases and that the system has been in use.
WARNING: The procedure below will replace the data in your existing Guard1 Plus SE Application database with the data from the Backup database. Verify that you do not need the information (Buttons, Downloads, Facilities) in the current database before continuing. If in doubt, back up the current Application database.
- Use SQL Enterprise Manager/Management Studio to restore the Backup database to current Application database (usually 'Guard1Plus').
- Remove the old SQL User (usually 'Guard') from the restored Application database.
- Add the SQL User (usually 'Guard') to the restored Application database and assign this user the db_Owner database role.
- 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.
- Type G1Cfg 0 then press Enter. In the Current Configuration window, under Data Sources And Connection Parameters, note the name of the Master Data Source.
- At the Command Prompt type G1Cfg 401;Supervisor User;Supervisor Password;Data Source Name then press Enter.
- 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 Master Data Source from Step 5
- Click Yes, then OK.
- Close all configuration windows and launch the Guard1 Plus SE Client.