Database

Configuring SQL Express for Mixed Mode Authentication This article describes how to enable SQL Express Mixed Mode Authentication. SQL Express is installed silently when using the prerequisites downloaded from Netaphor™, which installs the application for…

Connecting to the SiteAudit Database Netaphor SiteAudit™ can connect to databases on local or remote SQL servers. This article describes how to connect a SiteAudit database to monitor or view data that has been collected. If no SiteAudit database exists,…

Creating .BAK Backup in SiteAudit Viewer It is important to backup the Netaphor SiteAudit™ database periodically. How frequently the database is backed up should be dependent upon how critical the data is. In some environments, the data may not be critical…

Preparing SQL Server Express This document provides a set of step-by-step instructions for setting up SQL Server Express for Netaphor SiteAudit™. SQL Server Express Configuration The actions described in this article are not required when using the SQL…

Providing SiteAudit Database Access To access the Netaphor SiteAudit™ database, a user must have owner privileges first. This article describes how to give new users access to the SiteAudit database. Functional Security Once the SiteAudit administrator…

Restoring SAB Demo Database SAB backups / restores should only be done for quick assessments. Production databases should be backed up using SQL Management Studio or scripts that produce .BAK files. To create a backup of your database using SQL script, refer…

Scheduling SQL Backup & Shrinking Using the Windows Task Scheduler This article explains how to schedule SQL database backups and log file shrinking via script using the Windows Task Scheduler. Overview It is highly recommended that users regularly backup…

Shrink Database Log File This article describes how to shrink the Netaphor SiteAudit™ database log file. Shrinking the log file should be part of regular maintenance. The scripts below can be run from the SiteAudit Diagnostics > SQL Query tool or from…

In order to access databases on a SQL server, one must have a login account and be authenticated. The login is created by the SQL server system administrator and he/she indicates which type of authentication is required by the user. There are two forms of…

This article describes how to upgrade SiteAudit OnSite to a newer version of the software. There are two aspects to the upgrade: 1) Upgrading the SiteAudit software 2) Upgrading the SiteAudit database An upgrade can take from a few minutes to several hours.…