Back Up the Intranet

We recommend you backup your site completely on a daily basis as a minimum.

Backups include a copy of the intranet files as well as a copy of the database. If the intranet is running on a VM the backup process can consist of taking a snapshot of the VM. It should be noted that a snapshot of a VM will only include services running on the VM that the sanpshot is of, if the SQL server is running on a seperate VM then a snapshot of that will be required.

In order to successfully restore, backups need to be taken in the same time frame.

Intranet Files

To back up intranet files:

  1. Log into the Intranet
  2. Click on Admin
  3. Scroll to the bottom of the page
  4. Locate the ‘Drive Location’ in the Intranet Application column of the System Information section
  5. Copy this folder to create a backup

Additional Intranet Files

Other intranet files will also need to be backed up:

  1. Log into the Intranet
  2. Click in the Admin area > Security  tab
  3. Click File Migration Utility
  4. If you have files in an alternate location, you will see this location listed under Step One
  5. Copy this folder to create a backup if it is different than above

Manual Database Backup

To back up the database:

  1. Log into your database using SQL Management Studio
    • You can determine where your database is installed by logging into Railo (HTTP://YOURSERVERNAME/railo-context/admin/web.cfm) or Lucee (HTTP://YOURSERVERNAME/lucee/admin/web.cfm), click on Datasource under Services, click the pencil icon at the end of the entry
  2. Expand Databases
  3. Right click IntranetConnections
  4. Select Tasks
  5. Select Backup
  6. Verify the database is IntranetConnections and the backup type is Full
  7. Click Add under Destination
  8. Select your destination and provide a filename
  9. Click OK and the database backup will run

Repeat this process for the SQBoxStatistics database if you're on Version 14.0+.

Automated SQL Server Express Database Backups

In SQL Express, the same automated backup options are not available that the full version of SQL provides. In licensed versions of SQL backups can be created using scheduled maintenance tasks. Since SQL Express lacks the SQL Agent it is not possible to schedule maintenance tasks on Express versions.

Microsoft offers a workaround in their article How to schedule and automate backups of SQL Server databases in SQL Server Express.

Related articles