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:
- Log into the Intranet
- Click on Admin
- Scroll to the bottom of the page
- Locate the ‘Drive Location’ in the Intranet Application column of the System Information section
- Copy this folder to create a backup
Additional Intranet Files
Other intranet files will also need to be backed up:
- Log into the Intranet
- Click in the Admin area > Security tab
- Click File Migration Utility
- If you have files in an alternate location, you will see this location listed under Step One
- Copy this folder to create a backup if it is different than above
Manual Database Backup
To back up the database:
- 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
- Expand Databases
- Right click IntranetConnections
- Select Tasks
- Select Backup
- Verify the database is IntranetConnections and the backup type is Full
- Click Add under Destination
- Select your destination and provide a filename
- 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.