What is it and what it does
Purpose
The Sever Configuration Tool was developed to assist in the installation of Microsoft’s SQL Server and database on a Server Operating System to allow for the Estimating Link program on a network workstation to communicate with the SQL Database.
Primary Function
To install the SQL Server, create a database and add the requirement necessary for the communication between the Network server and the workstations on the network providing a multi-user environment. Also to schedule daily backups of the attached database.
Secondary Functions
- Manage Users: Allows for the viewing of what users are using a database.
- Connected Users: Allows for disconnecting users from the database.
- Get or delete a server key.
- Create Database: Allows for multiple databases to be created on a SQL Server instance.
- Backup Database: Allows for backup of a current database.
- Re-Index Database: Allow the user to re-index a database.
Database Tools
- Rollback Database: Allows for a rollback to a prior database version.
- Set Database to Muti-User: Allows change from a Single User database to a Multi-User database.
- Update Database Statistics: Updates the index to queries used in accessing a database.
- View/Change Database Location: Allows the user to change where periodic backups of the database are stored.
- Restore Database: Allow for restoring a database backup on an SQL instance.