How to Backup the RandRevit Database
The RandRevit database is where all the information for projects, tasks and more is housed, so having a current backup on hand is always a good idea.
Setting an Automated Backup in Settings
There is a configuration for this in Settings on the General tab to Backup the System Database.
The system will attempt, once per week, to make a backup of the RandRevit centralized database to the Backups folder defined in settings.
Manually Backing up the Database
Connecting to the database
RDP into the machine where the SQL Database is installed, if you are using the SQL database installed with Clarity it will be on your host server.
- Log onto the server as the Clarity Service account that runs the services and application pools, this should allow you to Log into SQL with Windows Authentication
- Open the SQL Management Studio
- You might want to pin this to the task bar
- Connect
- Expand Databases
- Right Click on RandRevit
- Tasks
- Backup
- Tasks
- In the Backup Database dialog verify the settings
- Select Add to add the backup location
- Browse to a location to save the backup and give it a name and ok out of all dialogs to save the backup with a .bak extension.
- Ok to backup
- When the backup completes you will see the following dialog