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.

image-1728412984486.png

The system will attempt, once per week, to make a backup of the RandRevit centralized database to the Backups folder defined in settings.

image-1728412918710.png

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
  • 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
Was this article helpful?
1 out of 1 found this helpful