Deprovision the restored database, Reinstall the database on the central stations – Welch Allyn Connex CS Central Station & Server - User Manual User Manual
Page 119
Connex CS Admin Guide
Connex Database Restore
113
Deprovision the Restored Database
Follow these steps if the restored database is part of a connected environment. A
connected environment is one in which:
•
Many central stations are deployed at the same site
•
AND a central server is deployed at the site
•
AND the data from all central stations is kept in sync by the Connex Data Sync
Service.
If the database is not part of a connected environment, it is not necessary to Deprovision
the database.
To Deprovision a database with the command line utility:
1.
Logon to the computer that hosts the restored database OR logon to a computer that
is connected to the host via the windows network.
2.
Open a command window and navigate to the directory where the Connex CS
Provisioning utility has been deployed. (To locate the deployment folder, search for the
program “WelchAllyn.Connex.ProvisioningUtility.exe” or consult the CS install
documentation.)
3.
Enter the following at the command prompt which specifies the database host
address, the database instance, the database name, and the parameter which
instructs the utility to Deprovision the database.
•
WelchAllyn.Connex.ProvisioningUtility.exe SERVERNAME=<server
name>\<instance name> DATABASENAME=WADB APPLYDEPROVSCRIPT
4.
Examine the messages produced by the Provisioning Utility to verify that the
operation succeeded.
Reinstall the database on the central stations
Follow these steps only if the database is restored on the server as part of a client-server
deployment, otherwise skip to
“Restart Services, Scheduled Tasks, and Open the CS
Application.”
on page 116.
To re-install the database on each central station:
1.
Open SQL Server management studio (SSMS). On CS central station this can be
done by searching SSMS from the windows start menu.
2.
Enter the correct login details in the pop-up dialog to enter SQL Server instance
name.
3.
Once SSMS is open, from the object explorer, select WADB database. Right click and
the select Delete.