Browse
Tools
Categories

Database

1 Configuring SQL Express for Mixed Mode Authentication

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…

2 Creating .BAK Backup in SiteAudit Viewer

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…

3 Preparing SQL Server Express

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…

4 Providing SiteAudit Database Access

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…

5 Restoring a Demo Database

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…

6 Scheduling SQL Backup & Shrinking Using the Windows Task Scheduler

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…

7 Shrink Database Log File

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…

8 SQL Server Authentication Modes

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…