17.1 Database Backup

Backing Up the Primary Database

To prevent database file corruption or other incidents that may prevent the server from starting normally, it is recommended that administrators back up the database after configuring classifications and policies.

The main steps for backing up the primary database are:

• First, stop the AnySecura Server and any other programs using the SECURE database.
• Open SQL Server 2000 Enterprise Manager or SQL Server 2005 Management Studio.
• Right-click the SECURE database and select All Tasks → Detach Database.

• After successfully detaching the database, administrators can copy the primary database files—SECURE.mdf and SECURE_Log.LDF—to the backup directory.
• Once detached, the SECURE entry will be removed from the Enterprise Manager. To restore the database, administrators need to select All Tasks → Attach Database and reattach the primary database in the Server installation directory.

The method above backs up the database by detaching it first and then copying the database files. Alternatively, you can stop the MSSQLSERVER service, copy the database files to the backup directory, and then restart the MSSQLSERVER service and the AnySecura Server. This achieves the same backup result.

Log Database Backup

Log data is stored daily in the DATA directory, which by default is located in the installation folder. Files are named by date. For example, for June 20, 2009, the files might include:

• SECURE _DATA.20090622.MDF
• SECURE _DATA.20090622_Log.LDF
• SECURE _DATA.20090622.X.MDF
• SECURE _DATA.20090622.X_Log

There are typically 2 to 10 files per day.

The main steps for backing up the log database are:

• Stop the AnySecura Server and MSSQLSERVER services.
• Copy the .MDF and .LDF database files to the backup directory.
• Restart the MSSQLSERVER service and the AnySecura Server.