Database Configuration
The Database Configuration tool provides the ability to perform maintenance operations on Desktop Authority's back end SQL databases. The supported operations include: backup/restore the database, shrink/increase the allocated database size, and maintenance operations such as rebuilding indexes and database consistency checks. The Database Configuration object is available exclusively to a Super User/Group. Non-Super Users/Groups do not have the ability to open the Database Configuration object.
The Database Configuration tool is broken up into two sections; Database Connection and Database Operations. Before any operations can be performed a connection to the database must be established. During installation, Desktop Authority creates a single named instance of the Microsoft SQL Server 2014 Express Edition. The named databases created within this SQL instance are DACONFIGURATION and DAREPORTING. The DACONFIGURATION database is where all of the Desktop Authority configuration data is stored. The DAREPORTING database is where the reporting data is stored.
Database connection
A connection to either database can be made using Windows Authentication mode or SQL Server Authentication mode.
Physical server
Enter the server or instance name containing the database to connect to. Click the dropdown list to select a database from the list of all named-instances found on the network. Click the Load all instances button to refresh the Physical server list with all server instances on the machine.
Authentication type
Select Windows to connect to SQL using a Microsoft Windows user account. Select SQL to connect to connect to the database using Mixed Mode Authentication (Windows Authentication and SQL Server Authentication).
Login
Enter the Windows/SQL login name.
Password
Enter the Windows/SQL login password.
Connect/Disconnect
Click Connect to establish a connection to the desired server. Click Disconnect to remove the database connection to the server.
Backup
Perform a backup
Create a complete backup copy of the selected database. The backup is stored in a separate location that is protected from the potential problems on the server. If the SQL server fails, or the database is damaged, the backup can be used to restore the database.
|
|
Note: A restore operation can be performed using the Desktop Authority Setup Tool. This tool can be found on the computer where Desktop Authority is installed to. |
Database name
Select the database to perform the backup or restore on from the drop list.
Backup file
Specify the location where the backup will be stored and its filename. Specify a local file path or a UNC path. Click the Browse button to browse out to a selected folder.
Backup media name
Provide informational text to aid in the identification of a backup set.
Backup media description
Provide informational text to aid in the identification of a backup set.
Backup
Click the Backup button to start the operation.
Shrink
Database name
Select the database to perform the shrink operation on from the drop list.
Shrink the database/Shrink the transaction Logs
Select either or both, Shrink the database and Shrink the transaction logs to reduce the size of all files in the database. File(s) are truncated to reflect freed space.
Shrink
Click Shrink to begin the selected shrink operation.
Increase database size
Database name
Select the database to perform the operation on from the drop list.
Existing database size
Displays the current size of the selected database in megabytes. The size includes data and transaction log files. Click Refresh to update the displayed value.
New database size (in MB)
Specify a new database size in megabytes.
Set new size
Click Set new size to increase the size of the database.
Perform maintenance on the database
Database name
Select the database to perform the operation on from the drop list.
Rebuild database indexes
Rebuilding indexes reorganizes the storage of the index data to remove fragmentation. This can improve disk performance by reducing the number of page reads required to obtain the requested data. Check this box to rebuild the database indexes.
Reset identity columns
Check this box to renumber the identity columns for all tables within the database.
Perform consistency checks
Check this box to check the consistency of the database and its indexes. If necessary this operation will rebuild the indexes and update the index statistics.
Perform maintenance
Click Perform maintenance to perform the selected maintenance operations.